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

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

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

You can merge the main document with the data source in Excel. In mail merge operations, Word is usually client.

Question 3

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

Accepted Answer

F9

Answer

Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.

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

When you press F9 or click Calc Sheet on the Calculation tab on the Tools/Options menu. Calculation also occur every time that you have save the file if you have the checkbox "Recalculate workbook before saving" checked under File> Options > Formulas.

Question 5

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

Accepted Answer

Both of A and B

Answer

In Excel 2016, 2013, 2010, 2007, click View > Show > Gridlines
For Excel 2003 and Earlier: Navigate to Tools > Optiions or Click Gridline tool on Forms toolbar.

Excel Practice Test

Excel Practice Test

Free Excel MCQ Questions and Answers