Question Detail

3-D reference in a formula ?

Spans worksheets
Can not be modified
Only appears on summary worksheets
Limits the formatting options

Answer: Option A

Similar Questions :

1. Formula palette is used to ?

format cells containing numbers
create and edit formulas containing functions
entered assumptions data
copy all cells

Answer: Option B

2. How we can view a cell comment ?

position the mouse pointer over the cell
click the comment command on the view menu
click the edit comment commands on the Insert menu
click the Display comment command on the window menu

Answer: Option A

3. Which of the following methods cannot be used to edit the content of cell ?

Pressing F2
Clicking the formula bar
Pressing the Alt key
Double clicking the cell

Answer: Option C

4. To drag a selected range of data to another worksheet in the same workbook, use the ?

Ctrl key
Shift key
Alt key
Tab key

Answer: Option A

5. Shortcut to delete the selected column ?

Ctrl + -
Alt + -
Shift + -
Insert + -

Answer: Option A

Read more from - MS Excel Questions Answers