MS excel set 10 Detailed Explanation And More Example

Question : 1

In Excel which of the following formulas is not entered correctly?

a) =10+50

b) =B7*B1

c) =B7+14

d) 10+50

Question : 2

In MS Access-,-a table can have__ primary key /keys.

a) One

b) Two

c) Three

d) Four

e) None of these

Question : 3

To center 'worksheet titles across a range of cells, you must

a) Select the cells containing the title text plus the range over which the title text is to be centered

b) Widen the columns

c) Select the cells containing the title text plus the range over which the title text is to be enfettered

d) Format the cells with the comma style

e) None of these

Question : 4

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

You can edit existing Excel data by pressing the

a) F1key

b) F2key

c) F3key

d) F4key

e) None of these

Question : 6

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