MS excel set 10 Detailed Explanation And More Example

Question : 1

When a range is selected, how can you activate the previous cell?

a) Press the Alt key

b) Press Tab

c) Press Enter

d) All of above

e) None of these

Question : 2

In Excel Status indicators are located on the

a) Vertical scroll bar

b) Horizontal scroll bar

c) Formula bar

d) Standard toolbar

Question : 3

Which area in an excel window allows entering values and formulas

a) Title bar

b) Menu bar

c) Formula bar

d) Standard toolbar

e) None of these

Question : 4

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

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

a) One

b) Two

c) Three

d) Four

e) None of these

Question : 6

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

a) =10+50

b) =B7*B1

c) =B7+14

d) 10+50