Exam 9: Excel_Module_2

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

The AVERAGE function requires that the argument be included within parentheses following the function name.

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.

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

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

Which of the following is a method of entering functions?

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

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

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

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

Using the Excel spell checker, you can ____.

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

____________________ 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.

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.

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

Clicking the Create Function box opens the Function Arguments dialog box.

The Insert Options button lists formatting options.

You can press the ____________________ key to quit Range Finder.