MS excel set 4 Detailed Explanation And More Example

Question : 1

In Excel name box

a) Shows the location of the previously active cell

b) Appears to the left of the formula bar

c) Appears below the status bar

d) Appears below the menu bar

Question : 2

Charts tips can

a) Show the formatting of a data label

b) Show the name of a data series

c) Show the value of data point

d) b and c

e) None of these

Question : 3

In Excel autofill feature

a) Extends a sequential series of data

b) Automatically adds range of cell values

c) Applies a boarder around the selected cells

d) None of the above

Question : 4

In Excel to drag a selected range of data to another worksheet in the same workbook, use the

a) Tab key

b) Alt key

c) Shift key

d) Ctrl key

Question : 5

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 : 6

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