MS excel set 11 Detailed Explanation And More Example

Question : 1

How many worksheets can a workbook have?

a) 3

b) 8

c) 255

d) All of above

e) None of these

Question : 2

Which area In an Excel window allows entering values and formulas?

a) Title Bar

b) Menu Bar

c) Formula Bar

d) Standard Tool Bar

e) None of these

Question : 3

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

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

Question : 5

In Excel which elements of worksheet can be protected from accidental modification ?

a) Contents

b) Objects

c) Scenarios

d) All of above

Question : 6

In Excel to copy cell contents using drag and drop press the

a) End key

b) Shift key

c) Ctrl key

d) Esc key