MS excel set 6 Detailed Explanation And More Example

Question : 1

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

a) worksheet

b) chart sheet

c) module sheet

d) data sheet

e) None of these

Question : 2

In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

a) Use Ctrl to select all three cells, then click the paste button on the standard toolbar

b) Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

c) Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

d) All of above

Question : 3

Which function Is not available In the Consolidate dialog box?

a) Pmt

b) Average

c) Max

d) Sum

e) None of these

Question : 4

The advantage of using a spreadsheet is :

a) calculations can be done automatically

b) changing data automatically updates calculations

c) more flexibility

d) all of the above

e) None of these

Question : 5

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

You can edit a cell by

a) Clicking the formula button

b) Double clicking the cell to edit it in-place

c) Selecting Edit > Edit Cell from the menu

d) All of above

e) None of these