Exam 2: Formulas, Functions, and Formatting

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

A(n)____________________ is a dot on the screen that contains a color.

You cannot format an entire column at once.

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

When you click the Decrease Font Size button,Excel assigns the next highest font size in the Font Size gallery.

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

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

Cooler colors tend to pull away from the reader._________________________

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

The ____ function determines the lowest number in a range.

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

The range automatically selected by Excel is always correct.

You can use the ____ to check which cells are referenced in the formula assigned to the active 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.

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

All of the following are valid Excel arithmetic operators EXCEPT ____.

You can press the ____________________ key to quit Range Finder.

While holding down the ALT key,you can select nonadjacent ranges and cells._________________________

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

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