Excel Test

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

• True
• False

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear

• True
• False

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

• True
• False

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

• Comma style format
• Percent style format
• Accounting number format
• Currency style format

Which of the following is the path to the Conditional Formatting button?

• (HOME tab | Editing group)
• (FORMATTING tab | Styles group)
• (STYLES tab | Formatting group)
• (HOME tab | Styles group)

The ____ function displays the highest value in a range.

• MIN
• MAX
• SUM
• AVERAGE

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

• 40
• 48
• 26
• 13

Which of the following happens when you enter the formula =G15 into a cell?

• Excel recalculates all formulas in the worksheet
• Excel assigns the sum of the values in the previous 15 cells to the active cell
• Excel assigns the value in cell G15 to the active cell
• Nothing; =G15 is an invalid formula

Clicking the ____ opens the Insert Function dialog box.

• Insert Function box in the formula bar
• Function dialog box launcher (HOME tab | Calculations group)
• Function button (HOME tab | Function group)
• Functions & Formulas button on the status bar

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

• ^
• *
• %
• >