Exam 4: Excel 2 Formulas, Functions, and Formatting

You can use the arrow keys to complete an entry in Point mode.

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

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

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____________________ colors.

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

The ____ function determines the lowest number in a range.

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

A ____ is text and graphics that print at the top of each page.

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.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Using the Excel spell checker, you can ____.

A ____ is a prewritten formula that is built into Excel.

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.

The Accounting number format assigns a floating dollar sign. _________________________