Free Excel MCQ Questions and Answers

Question 1

Which of the following methods for modifying cell content is incorrect?

Accepted Answer

Press the Alt key

Answer

Press the F2 key

Answer

Double click the cell

Answer

Click the formula bar

Question 2

In Excel, you can integrate the primary document with the data source. Word is commonly used in mail merging operations.

Accepted Answer

Client

Answer

Server

Answer

Source

Answer

None of these

Question 3

If Excel's Auto Calculate option is disabled, how can you update the values of formula cells?

Accepted Answer

F9

Answer

F11

Answer

F10

Answer

F8

Question 4

In Excel, where can you switch between automated and manual calculation modes?

Accepted Answer

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

Answer

Double CAL indicator on status bar

Answer

Both A and B

Answer

None of these

Question 5

In an Excel worksheet, how do you show or hide the gridline?

Accepted Answer

Both of A and B

Answer

Click  Gridline tool on Forms toolbar

Answer

Go to Tools > Options > View tab and mark or remove the checkbox name Gridline

Answer

None of these

Question 6

Which of the Excel screen components can't be turned on or off?

Accepted Answer

None of these

Answer

Tool Bar

Answer

Formula Bar

Answer

Status Bar

Question 7

It is acceptable to let long text stream into adjoining cells on a worksheet when

Accepted Answer

No date will be entered in the adjacent cells

Answer

There is not time to format the text

Answer

There is no suitable abbreviation for the text

Answer

Data will be entered in the adjacent cells

Question 8

In Excel, the shortcut key Ctrl + D will

Accepted Answer

Fill down in the selection

Answer

Apply double underline for the active cell

Answer

Open the font dialog box

Question 9

You'll be able to move a sheet from one workbook into a new book by

Accepted Answer

From Edit menu choose Move or Copy the select (new book) from To Book list and click OK

Answer

From edit menu choose Move or Copy sheet, mark the Create a copy and click OK

Answer

From Edit menu choose Move of Copy the choose (Move to end) and click OK

Question 10

Click on the cell beneath the numbers in the column of numbers to quickly add them up.

Accepted Answer

Click the AutoSum button on the Standard toolbar, then press ENTER.

Answer

Click Subtotals on the Data menu.

Answer

View the sum in the formula bar.

Answer

Click the Sum button on the Standard toolbar.