Microsoft Excel Questions & Answers - Page 11

51.

The shortcut key Ctrl + R is used in Excel to

A.

Right align the content of a cell

B.

Remove the contents of selected cells

C.

Fill the selection with active cells to the right

D.

None of above

Correct answer is C

No explanation has been provided for this answer.

52.

Ctrl + D shortcut key in Excel will

A.

Open the font dialog box

B.

Apply double underline for the active cell

C.

Fill down in the selection

D.

None of above

Correct answer is C

No explanation has been provided for this answer.

53.

You can auto fit the width of a column in Excel by

A.

Double clicking on the column name on column header

B.

Double click on the cell pointer in worksheet

C.

Double clicking on the right border of the column header

D.

Double clicking on the left border of the column header

Correct answer is C

You can auto fit the width of column by double clicking on the column right border on column header.

54.

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

A.

Doctor’s symbol (Big Plus)

B.

Small thin plus icon

C.

Mouse Pointer with anchor at the tip

D.

None of the above

Correct answer is B

Small thin plus icon cell pointer indicates that you can fill series.

55.

Which of the following is not true regarding Conditional Formatting?

A.

You can add more than one condition to check

B.

You can set condition to look for Bold and apply Italics on them

C.

You can apply Font, border and pattern formats that meets the specified conditions

D.

You can delete any condition from Conditional Formatting dialog box if it is not requried

Correct answer is B

No explanation has been provided for this answer.