MS excel set 10 Detailed Explanation And More Example

Question : 1

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

e) None of these

Question : 2

In Excel the chart wizard

a) Can place a chart on a new chart sheet or on any sheet in the workbook

b) Can only place a chart on new chart sheet

c) Can only place a chart on a new blank worksheet

d) Can only be used to create embedded charts

Question : 3

Which of the following Excel screen components can NOT be turned on or off ?

a) Formula Bar

b) Status Bar

c) Tool Bar

d) All of above

e) None of these

Question : 4

Comments can be added to cells using.....

a) Edit-> Comments

b) Insert •> Comment

c) Fl I e-> Comments

d) View-> Comments

e) None of these

Question : 5

In Excel to center worksheet titles across a range of cell, you must

a) Select the cells containing the title text and use the fill handle to center the text across a range of cells

b) Widen the columns

c) Select the cells containing the title text and use the fill handle to center the text across a range of cells

d) Widen the column

Question : 6

Which elements of a worksheet can be protected from accidental modification?

a) Contents

b) Objects

c) Scenarios

d) All of the above

e) None of these