Question 1

In Excel, functions can be entered using any of the following methods except the ____.
A)Function command on the Tools menu
B)keyboard or mouse
C)Insert Function box in the formula bar
D)AutoSum command on the Formulas tab

Accepted Answer

The Function command is not located on the Tools menu in Excel. Functions are typically inserted using the Insert Function dialog box, directly typing into the cell/formula bar, or using the AutoSum feature on the Formulas tab.

Question 2

To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.
A)ALT+ENTER
B)CTRL+ENTER
C)SHIFT+ENTER
D)TAB+ENTER

Accepted Answer

Pressing ALT+ENTER will create a new line within a cell in Microsoft Excel.

Question 3

To instruct Excel to display a hidden column, position the mouse pointer to the ____.
A)left of the column heading boundary where the hidden column is located and then drag to the right
B)right of the column heading boundary where the hidden column is located and then drag to the left
C)left of the column heading boundary where the hidden column is located and then drag to the left
D)right of the column heading boundary where the hidden column is located and then drag to the right

Accepted Answer

D

Question 4

To check the spelling of the text in a single cell, ____ to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon.
A)double-click the formula bar
B)right-click the cell
C)double-click the cell
D)right-click the formula bar

Accepted Answer

Double-clicking the cell makes the formula bar active, allowing you to then click the Spelling button on the Review tab to check the spelling of the text within that cell.

Question 5

To save a previously saved workbook with a new name or on a different drive, ____.
A)click the Save button on the Quick Access Toolbar
B)click Save As on the File menu
C)press CTRL+S
D)click Save on the File menu

Accepted Answer

The answer of To save a previously saved workbook with...

Question 6

Which view allows you to create or modify a worksheet while viewing how it will look in printed format.
A)Print View
B)Normal View
C)Page Layout View
D)Print Layout View

Accepted Answer

Page Layout View allows you to see how the worksheet will look when printed, while also giving you the ability to modify the content on the worksheet. This view also shows page margins and breaks, making it easier to adjust the layout of your worksheet for printing purposes.

Question 7

When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.
A)Smart Tag Actions
B)AutoCorrect Options
C)Trace Error
D)Auto Fill Options

Accepted Answer

The green triangle indicates a trace error and clicking on it will give options to trace and correct the error in the formula. Smart Tag Actions, AutoCorrect Options, and Auto Fill Options do not relate to error correction in formulas.

Question 8

All of the following are valid Excel arithmetic operators except ____.
A)^
B)*
C)%
D)>

Accepted Answer

The caret symbol (^) is used for exponentiation, the asterisk symbol (*) is used for multiplication, and the percent symbol (%) is used for percentages. The greater than symbol (>) is not a valid arithmetic operator in Excel.

Question 9

If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____.
A)only the text in the selected cell
B)the remainder of the worksheet, including notes and embedded charts
C)the spelling of all sheets in the workbook
D)the remainder of the worksheet, not including notes and embedded charts

Accepted Answer

When the spell checker is started in Excel with a single cell selected and the formula bar not active, Excel checks the remainder of the worksheet, including notes and embedded charts. This means it does not limit its check to just the selected cell but extends it to the rest of the content on the worksheet.

Question 10

Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.
A)Rule Format
B)New Rule
C)New Format
D)Format Rule

Accepted Answer

The correct option is "New Rule" as it opens the New Formatting Rule dialog box. The other options listed are not present in the Conditional Formatting gallery.

Question 11

____ means that the width of the column will be increased or decreased so the widest entry will fit in the column.
A)Auto column adjust
B)Width fit
C)Auto adjust
D)Best fit

Accepted Answer

Best fit means adjusting the column width so that the widest entry fits in the column, allowing for easy reading and preventing the information from being cut off or truncated.

Question 12

How do you activate Range Finder to verify a formula in a cell?
A)Range Finder does not verify formulas
B)Press the ESC key
C)Double-click in the cell
D)Click the Range Finder button

Accepted Answer

Double-clicking in the cell activates Range Finder, which helps in verifying and visualizing the cell ranges involved in a formula by highlighting them.

Question 13

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
A)40
B)26
C)48
D)13

Accepted Answer

According to the order of operations, multiplication should be done first, so 8 * 3 equals 24. Then the addition of 2 should be done, resulting in 26.

Question 14

Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.
A)recalculates new
B)recalculates some
C)recalculates old
D)recalculates all

Accepted Answer

Excel automatically recalculates all formulas every time a value is entered into a cell. This ensures that all formulas and dependent cells are updated with the new value.

Question 15

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____.
A)1732
B)1832
C)1932
D)2032

Accepted Answer

Excel automatically adds 1900 to two-digit years between 00 and 29, and 2000 to two-digit years between 30 and 99.

Question 16

As with column widths, when you decrease the row height to 0, the row is ____.
A)hidden
B)visible temporarily at the top of the worksheet
C)deleted
D)visible temporarily on the left side of the worksheet

Accepted Answer

When you decrease the row height to 0, the row is hidden.

Question 17

If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column's width.
A)Column Width
B)Adjust Width
C)Width Adjustment
D)Increase Column

Accepted Answer

The correct command to change the column's width is "Column Width" which can be accessed by right-clicking the column heading. The other options provided in the question are not correct commands for changing the column width in Excel.

Question 18

The ____ button lists formatting options following an insertion of cells, row, or columns.
A)Paste Options
B)Insert Options
C)Auto Fill Options
D)AutoCorrect Options

Accepted Answer

The Insert Options button appears after you insert cells, rows, or columns and allows you to choose how to format the inserted cells, rows, or columns. It gives you options like shifting adjacent cells, copying formulas or formats, or inserting entire rows or columns.

Question 19

When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____.
A)8.43 characters, or 64 pixels
B)64 characters, or 8.43 pixels
C)12.75 points, or 17 pixels
D)17 points, or 12.75 pixels

Accepted Answer

By default, all columns in Excel have a width of 8.43 characters, or 64 pixels.

Question 20

Using the ____ button on the Ribbon instructs Excel to display additional decimal places in a cell.
A)AutoFormat
B)Currency Style
C)Increase Decimal
D)Percent Style

Accepted Answer

The Increase Decimal button on the Ribbon allows you to add decimal places to a selected cell's value, resulting in more precise calculations. Choosing Currency or Percent Style will apply pre-set formatting to a cell, but will not necessarily add or remove decimal places. AutoFormat is a feature that applies pre-defined formatting to a range of cells based on a selected style, but does not specifically address decimal places.

Quiz 9: Excel: Formulas, Functions, Formatting, and Web Queries

In Excel, functions can be entered using any of the following methods except the ____.

To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.

To instruct Excel to display a hidden column, position the mouse pointer to the ____.

To check the spelling of the text in a single cell, ____ to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon.

To save a previously saved workbook with a new name or on a different drive, ____.

Which view allows you to create or modify a worksheet while viewing how it will look in printed format.

When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.

All of the following are valid Excel arithmetic operators except ____.

If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____.

Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.

____ means that the width of the column will be increased or decreased so the widest entry will fit in the column.

How do you activate Range Finder to verify a formula in a cell?

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____.

As with column widths, when you decrease the row height to 0, the row is ____.

If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column's width.

The ____ button lists formatting options following an insertion of cells, row, or columns.

When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____.

Using the ____ button on the Ribbon instructs Excel to display additional decimal places in a cell.