Exam 10: Excel: Formulas, Functions, and Formatting

The ____ function determines the lowest number in a range.

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

The range automatically selected by Excel is always correct.

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

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

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.

Modified Multiple Choice When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

The most common error when entering a formula is to reference the wrong cell in the formula.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

You cannot format an entire column at once.

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

____________________ colors jump out of a dark background and are easiest to see.

The / arithmetic operator indicates ____________________.

The ____ function displays the highest value in a range.

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.