MS Excel MCQs

Question 1

Which of the following options is not located in the Page Setup dialog box?

Accepted Answer

Page Break Preview

Answer

Page Orientation

Answer

Margins

Answer

Headers and Footers

Question 2

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Accepted Answer

Line chart

Answer

Pie chart

Answer

Row chart

Answer

Column chart

Question 3

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Accepted Answer

Press Ctrl + Home

Answer

Press Home

Answer

Press Shift + Home

Answer

Press Alt + Home

Question 4

Which of the following methods can not be used to edit the contents of a cell?

Accepted Answer

Press the Alt key

Answer

Clicking the formula bar

Answer

Pressing the F2 key

Answer

Double clicking the cell

Question 5

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

Accepted Answer

Press Esc

Answer

Press the Erase key

Answer

Press the Enter button

Answer

Press the Edit Formula button

Question 6

To view a cell comment

Accepted Answer

Position the mouse pointer over the cell

Answer

Click the edit comment command on the insert menu

Answer

Click the display comment command on the window menu

Answer

Click the comment command on the view menu

Question 7

When you want to insert a blank embedded excel object in a word document you can

Accepted Answer

Click the object command on the insert menu

Answer

Click the office links button on the standard toolbar

Answer

Click the create worksheet button on the formatting toolbar

Answer

Click the import excel command on the file menu

Question 8

To save a workbook, you:

Accepted Answer

Click the save button on the standard toolbar from the menu

Answer

Press Ctrl+ F5

Answer

Click Save on the Windows Start button

Answer

Select Edit > Save

Question 9

You can edit a cell by

Accepted Answer

Double clicking the cell to edit it in-place

Answer

Clicking the formula button

Answer

Selecting Edit > Edit Cell from the menu

Answer

None of above