MS excel set 11 Detailed Explanation And More Example

Question : 1

In Excel to view a cell comment

a) Click the edit comment command on the insert menu

b) Click the display comment command on the window menu

c) Position the mouse pointer over the cell

d) Click the comment command on the view menu

Question : 2

A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button......

a) nothing will print because some cells with data have been omitted

b) only the cells with gray back-ground will print

c) the whole sheet will print

d) only the cells with white background will print

e) None of these

Question : 3

In Excel what does SUMIF function do?

a) Adds up cell values based on a condition

b) Adds all the numbers in a range of cells

c) Returns a subtotal in a list or database

d) All of above

Question : 4

How many worksheets can a workbook have?

a) 3

b) 8

c) 255

d) All of above

e) None of these

Question : 5

How are data organised in a spreadsheet?

a) Lines and spaces

b) Layers and planes

c) Height and width

d) Rows and columns

e) None of these

Question : 6

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

a) Right click on Sheet Tab of third sheet and choose Delete from the context menu

b) Click on Sheet 3 and from Edit menu choose Delete

c) Click on Sheet 3 and from Edit menu choose Insert

d) All of above

e) None of these