Exam 8: Excel: Formulas, Functions, and Formatting

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Which of the following calculations multiplies 23 by 0.01?

The function,or ____________________,of a worksheet is to provide a user with direct ways to accomplish tasks.

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

The Accounting number format assigns a floating dollar sign._________________________

To paste copied cell contents,you can press the ____ keys.

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Opens the Format Cells dialog box.

A ____ is text and graphics that print at the bottom of every page.

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

To set row height to best fit,____________________ the bottom boundary of the row heading.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -A prewritten formula built into Excel.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

The Insert Options button lists formatting options.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -A formula in a cell that contains a reference back to itself.

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Spell-checking a worksheet.