MS Excel MCQs

Question 1

Where can you change automatic or manual calculation mode in Excel?

Accepted Answer

Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button

Answer

Double CAL indicator on status bar

Answer

Both of above

Answer

None of above

Question 2

How can you show or hide the gridlines in Excel Worksheet?

Accepted Answer

Both of above

Answer

Go to Tools > Options > View tab and mark or remove the check box named Gridline

Answer

Click Gridline tool on Forms toolbar

Answer

None of above

Question 3

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

Accepted Answer

None of above

Answer

Formula Bar

Answer

Status Bar

Answer

Tool Bar

Question 4

What happens when you press Ctrl + X after selecting some cells in Excel?

Accepted Answer

The cells selected are marked for cutting

Answer

The cell content of selected cells disappear from cell and stored in clipboard

Answer

The selected cells are deleted and the cells are shifted left

Answer

The selected cells are deleted and cells are shifted up

Question 5

Which of the following option is not available in Paste Special dialog box?

Accepted Answer

SQRT

Answer

Add

Answer

Subtract

Answer

Divide

Question 6

Which command will you choose to convert a column of data into row?

Accepted Answer

Paste Special > Transpose

Answer

Cut and Paste

Answer

Both of above

Answer

None of above

Question 7

It is acceptable to let long text flow into adjacent cells on a worksheet when

Accepted Answer

No data will be entered in the adjacent cells

Answer

Data will be entered in the adjacent cells

Answer

There is no suitable abbreviation for the text

Answer

There is not time to format the text

Question 8

Which of the cell pointer indicates you that you can make selection?

Accepted Answer

Doctor’s symbol (Big Plus)

Answer

Small thin plus icon

Answer

Mouse Pointer with anchor at the tip

Answer

None of above

Question 9

Which of the cell pointer indicates that you can fill series?

Accepted Answer

Small thin plus icon

Answer

Doctor’s symbol (Big Plus)

Answer

Mouse Pointer with anchor at the tip

Answer

None of above