Free Excel MCQ Questions and Answers — Questions and Answers

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

Press the F2 key
Press the Alt key (Correct answer)
Double click the cell
Click the formula bar

Correct answer: Press the Alt key

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.

Client (Correct answer)
Server
Source
None of these

Correct answer: Client

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?

F11
F10
F9 (Correct answer)
F8

Correct answer: F9

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?

Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button (Correct answer)
Double CAL indicator on status bar
Both A and B
None of these

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

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?

Click Gridline tool on Forms toolbar
Go to Tools > Options > View tab and mark or remove the checkbox name Gridline
Both of A and B (Correct answer)
None of these

Correct answer: Both of A and B

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.

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

Tool Bar
Formula Bar
Status Bar
None of these (Correct answer)

Correct answer: None of these

Show Formula bar option by clciking the File (or Office button) > Options > Advances > Display> Show Formula bar. In earlier version of Excel, you could hide the status bar if you wanted more space available for your worksheets. However, the capability was removed starting with Excel 2017. In earlier version of Excel, yoou could hide the tool bar as per requirement. However, that capability was removed starting Excel 2007 and introduced Ribbon.

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

There is not time to format the text
There is no suitable abbreviation for the text
Data will be entered in the adjacent cells
No date will be entered in the adjacent cells (Correct answer)

Correct answer: No date will be entered in the adjacent cells

When there is no data in the adjacent cells, long text flows into adjacent cells on the worksheet. As soon as data is entered into the adjacent cells, text will be visible upto cell length in which data is entered. For full visibility of data either we need o increase the length of cell or wrap text in particular cell.

Question 8: In Excel, the shortcut key Ctrl + D will

Apply double underline for the active cell
Fill down in the selection (Correct answer)
Open the font dialog box

Correct answer: Fill down in the selection

Ctrl + D fills the cell beneath with the contents of the selected cell in column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.

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

From Edit menu choose Move or Copy the select (new book) from To Book list and click OK (Correct answer)
From edit menu choose Move or Copy sheet, mark the Create a copy and click OK
From Edit menu choose Move of Copy the choose (Move to end) and click OK

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

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.

Click the AutoSum button on the Standard toolbar, then press ENTER. (Correct answer)
Click Subtotals on the Data menu.
View the sum in the formula bar.
Click the Sum button on the Standard toolbar.

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

The statement you provided is not entirely accurate. To quickly add up the numbers in a column in Microsoft Excel, you should follow these steps: 1. Click on the cell beneath the numbers in the column where you want the sum to appear. 2. Type the formula "=SUM(" (without the quotes). 3. Click and drag to select all the cells containing the numbers you want to add up. 4. Close the parentheses ")" and press ENTER. The AutoSum button on the Standard toolbar is another way to quickly sum up a range of cells, but it doesn't automatically detect the range you want to sum. Instead, it places the SUM function in the active cell and you need to manually select the range by clicking and dragging or typing the range manually after clicking the AutoSum button. So, the correct statement would be: "To quickly add up the numbers in a column in Excel, click on the cell beneath the numbers, then type the formula '=SUM(' and select the range of cells, close the parentheses and press ENTER."

Question 11: if you only want to copy the formula result and not the original formula. Once the insertion point is in the cell you wish to copy to, you would copy the cell containing the formula. Next, what?

Click the Paste button on the Standard toolbar.
Click the arrow on the Copy button on the Standard toolbar.
Click the arrow on the Paste button on the Standard toolbar, then click Values. (Correct answer)
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

Correct answer: Click the arrow on the Paste button on the Standard toolbar, then click Values.

After copying the cell containing the formula, you can follow these steps to paste only the formula result (not the original formula): 1. Click on the cell where you want to paste the formula result (the destination cell). 2. Paste the cell containing the formula by either: a. Pressing Ctrl + V (or Command + V on Mac) on your keyboard, or b. Clicking the Paste button on the Standard toolbar or c. Right-clicking the destination cell and selecting "Paste" from the context menu. 3. After you perform the above action, the Paste Options button will appear next to the pasted cell. 4. Click the arrow on the Paste Options button, which will open a menu with different paste options. 5. Select "Values" from the paste options menu. This will paste only the calculated result of the formula into the destination cell, without retaining the original formula itself. By choosing the "Values" option, you remove the formula and keep only the resulting value in the destination cell. This can be useful when you want to eliminate the dependency on the original formula and keep the static value that the formula produces.

Question 12: How can the column width be adjusted to fit the contents?

Double-click the boundary to the right of the column heading. (Correct answer)
Single-click the boundary to the left of the column heading.
Press Fn and double-click anywhere in the column.
Press ALT and single-click anywhere in the column.

Correct answer: Double-click the boundary to the right of the column heading.

Double-clicking the boundary on the right edge of a column heading triggers auto-fit, resizing the column to its widest content. The other actions—single-clicking the left boundary or using Fn/ALT key combinations—do not perform this auto-resize.

Question 13: Every new workbook comes with three worksheets. If you'd like, you can alter that automatic number.

TRUE
FALSE (Correct answer)

Correct answer: FALSE

False. By default, every new workbook in Microsoft Excel comes with only one worksheet. However, you can add or delete worksheets as needed. If you want to start a new workbook with a specific number of worksheets, you can create a custom template or modify Excel's default template to include the desired number of worksheets. But out of the box, Excel provides just one worksheet for new workbooks.

Question 14: What is the meaning of ######?

The cell is not wide enough. (Correct answer)
The cell has the wrong data.
You've entered a number wrong.
You've misspelled something.

Correct answer: The cell is not wide enough.

The meaning of "######" in Microsoft Excel is a display that indicates the cell contents are too wide to fit within the column width. When you see "######" in a cell, it means the content is not fully visible due to insufficient column width.

Question 15: Click a cell in the row directly above where you want the new row to go in order to add a new row.

TRUE (Correct answer)
FALSE

Correct answer: TRUE

In Microsoft Excel, if you want to add a new row, you can do it by clicking on a cell in the row directly above where you want the new row to be inserted.

Question 16: Which key do you use to combine two or more worksheets that are not adjacent?

CTRL
SHIFT (Correct answer)
TAB
ALT

Correct answer: SHIFT

To combine two or more worksheets that are not adjacent in Microsoft Excel, you can use the "CTRL" key, not the "SHIFT" key.

Free Excel MCQ Questions and Answers

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