MS excel set 10 Detailed Explanation And More Example

Question : 1

Which area in an excel window allows entering values and formulas

a) Title bar

b) Menu bar

c) Formula bar

d) Standard toolbar

e) None of these

Question : 2

In Excel to create a formula, you can use

a) Values but not cell references

b) Cell references but not values

c) Values or cell references although not both at the same time

d) Value and cell references

Question : 3

When you print preview a worksheet

a) the entire worksheet is displayed

b) the selected range is displayed

c) the active portion of the worksheet is displayed

d) All of the above

Question : 4

When a range is selected, how can you activate the previous cell?

a) Press the Alt key

b) Press Tab

c) Press Enter

d) All of above

e) None of these

Question : 5

What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

a) Spreadsheet program

b) Database program

c) Word processor program

d) Desktop publisher program

e) None of these

Question : 6

To center 'worksheet titles across a range of cells, you must

a) Select the cells containing the title text plus the range over which the title text is to be centered

b) Widen the columns

c) Select the cells containing the title text plus the range over which the title text is to be enfettered

d) Format the cells with the comma style

e) None of these