MS Excel MCQs

Question 1

Which of the cell pointer indicate that you can move the content to other cell?

Accepted Answer

Mouse Pointer with anchor at the tip

Answer

Doctor’s symbol (Big Plus)

Answer

Small thin plus icon

Answer

None of above

Question 2

You can auto fit the width of column by

Accepted Answer

Double clicking on column right border on column header

Answer

Double clicking on the column name on column header

Answer

Double click on the cell pointer in worksheet

Answer

Double clicking on the column left border of column header

Question 3

Long text can be broken down into many lines within a cell. You can do this through

Accepted Answer

Wrap Text in Format > Cells

Answer

Justify in Edit > Cells

Answer

Text Wrapping in Format > Cells

Answer

All of above

Question 4

MS Excel provides the default value for step in Fill Series dialog box

Accepted Answer

1

Answer

0

Answer

5

Answer

10

Question 5

When a row of data is to be converted into columns

Accepted Answer

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Answer

Copy the cells in row, select the same number of cells in row and paste

Answer

Copy the cells in column then choose Paste Special, then click Transpose and OK

Answer

Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK

Question 6

Ctrl + D shortcut key in Excel will

Accepted Answer

Fill down in the selection

Answer

Open the font dialog box

Answer

Apply double underline for the active cell

Answer

None of above

Question 7

The shortcut key Ctrl + R is used in Excel to

Accepted Answer

Fill the selection with active cells to the right

Answer

Right align the content of cell

Answer

Remove the cell contents of selected cells

Answer

None of above

Question 8

The command Edit > Fill Across Worksheet is active only when

Accepted Answer

When many sheets are selected

Answer

One sheet is selected

Answer

When no sheet is selected

Answer

None of above

Question 9

Which of the following series type is not valid for Fill Series dialog box?

Accepted Answer

Time

Answer

Linear

Answer

Growth

Answer

Autofill