Exam 2: Formulas, Functions, and Formatting

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.

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

The / arithmetic operator indicates ____________________.

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

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

Moving from left to right,the first calculation in the order of operations is negation (-).

The Accounting number format assigns a floating dollar sign._________________________

The ____ function displays the highest value in a range.

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

A formula in a cell that contains a reference back to itself is called a(n)____________________.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

The default view in Excel is called ____ view.

You can click the ____ button to undo an automatic correction.

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

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Which of the following is a method of entering functions?

The Insert Options button lists formatting options.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

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