MS excel set 10 Detailed Explanation And More Example

Question : 1

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

You can edit existing Excel data by pressing the

a) F1key

b) F2key

c) F3key

d) F4key

e) None of these

Question : 3

To apply Goal Seek command your cell pointer must be in

a) The Changing cell whose value you need to find

b) The Result Cell where formula is entered

c) The cell where your targeted value is entered

d) All of above

e) None of these

Question : 4

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

How do you select an entire column?

a) Select Edit > Select > Column from the menu

b) Click the column heading letter

c) Hold down the shift key as you click anywhere in the column,

d) Hold down the Ctrl key as you click anywhere in the column

e) None of these

Question : 6

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