FREE Excel MCQ Questions and Answers

0%

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

Correct! Wrong!

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

How can the column width be adjusted to fit the contents?

Correct! Wrong!

What is the meaning of ######?

Correct! Wrong!

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.

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

Correct! Wrong!

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.

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

Correct! Wrong!

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

In Excel, the shortcut key Ctrl + D will

Correct! Wrong!

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.

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

Correct! Wrong!

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.

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

Correct! Wrong!

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.

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

Correct! Wrong!

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.

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

Correct! Wrong!

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

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

Correct! Wrong!

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.

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

Correct! Wrong!

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.

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

Correct! Wrong!

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.

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

Correct! Wrong!

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

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?

Correct! Wrong!

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.

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

Correct! Wrong!

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."

Premium Tests $49/mo
FREE October-2024