MS excel set 4 Detailed Explanation And More Example

Question : 1

When integrating word and excel, word is usually the

a) Server

b) Destination

c) Client

d) Both b and c

e) None of these

Question : 2

It is acceptable to let long text flow into adjacent cells on a worksheet when

a) data will be entered in the adjacent cells

b) no data will be entered in the adjacent cells

c) there is no suitable abbreviation for the text

d) there is not time to format the text

e) None of these

Question : 3

Gridlines

a) May be turned off for display but turned on for printing

b) May be turned on or off for printing

c) The be turned off for display and printing

d) a, b and c

e) None of these

Question : 4

You can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on the shortcut menu

c) With buttons on the standard toolbars

d) All of the above

e) None of these

Question : 5

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

e) None of these

Question : 6

You can insert labels for

a) All the data markers on a chart

b) A data series

c) A selected data marker

d) All

e) None of these