MS excel set 13 Detailed Explanation And More Example

Question : 1

You can open the consolidate dialog box by choosing Consolidate from the..... menu.

a) Insert

b) Format

c) Tools

d) Data

e) None of these

Question : 2

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

e) None of these

Question : 3

To select a column the easiest method is to........

a) Double click any cell in the column

b) Drag from the top cell in the column to the last cell in the column

c) click the column heading

d) click the column label

e) None of these

Question : 4

In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

a) Rows and columns

b) Headings

c) Speed

d) None

Question : 5

In Excel which do you press to enter the current date in a cell?

a) Ctrl + Shift + :

b) Ctrl + ;

c) Ctrl + F10

d) All of above

Question : 6

Which Chart can be created in Excel?

a) Area

b) Line

c) Pie

d) All of the above

e) None of these