MS Excel MCQ (Multiple Choice Questions)

Attention Please! All MCQ's have four options. You can see the correct answer with detail explanation by clicking "Check Answer" button. You can also minimize the answer by clicking the Check answer button again.

Which of the following is not a valid Zoom percentage in Excel?

A) 10
B) 100
C) 300
D) 500
E) None of above

Check Answer

500% is not a valid zoom percentage in Excel.
The maximum zoom percentage in Excel is 400% and the minimum zoom percentage in Excel is 10%.

When you print preview a worksheet

A) the entire worksheet is displayed
B) the selected range is displayed
C) the active portion of the worksheet is displayed
E) All of above

Check Answer

The correct answer is ” All of the above”

To drag a selected range of data to another worksheet in the same workbook, use the

A) Tab key
B) Alt key
C) Shift key
D) Ctrl key
E) None of above

Check Answer

The correct answer is “Ctrl key”

To autofit the width of column

A) Double click the right border of the column
B) Double click the left border of the column
C) Double click the column header
D) All of above
E) None of above

Check Answer

The correct answer is “Double click the right border of the column”

To insert three columns between columns D and E you would

A) Select column D
B) Select column E
C) Select columns E, F, and G
D) Select columns D, E, and F
E) None of above

Check Answer

The correct answer is “Select column E.”

You can activate a cell by

A) Pressing the Tab key
B) Clicking the cell
C) Pressing an arrow key
D) All of above
E) None of above

Check Answer

The correct answer is All of the above.

Comments put in cells are called

A) Smart Tip
B) Cell Tip
C) Web Tip
D) Soft Tip

Check Answer

The correct answer is Cell Tip.