Microsoft Excel Questions & Answers - Page 2

Share on
6.

What symbol is used before a number to make it a label in Excel?

A.

” ( quote )

B.

= ( equal )

C.

_ ( underscore )

D.

‘ ( apostrophe )

Correct answer is D

An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

7.

Which of the following is an absolute cell reference in Excel?

A.

!A!1

B.

$A$1

C.

#a#1

D.

A1

Correct answer is B

The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

8.

When you copy a formula

A.

Excel erases the original copy of the formula

B.

Excel edits cell references in the newly copied formula

C.

Excel adjusts absolute cell references

D.

Excel doesn’t adjust relative cell references

Correct answer is B

No explanation has been provided for this answer.

9.

Right clicking something in Excel

A.

Deletes the object

B.

Nothing. The right mouse button is there for left handed people

C.

Opens a shortcut menu listing everything you can do to the object

D.

Selects the object

Correct answer is C

No explanation has been provided for this answer.

10.

To save a workbook, you

A.

Click the save button on the standard toolbar from the menu

B.

Press Ctrl+ F5

C.

Click Save on the Windows Start button

D.

Select Edit > Save

Correct answer is A

No explanation has been provided for this answer.