Exam 9: Excel_Module_2

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.

Cooler colors tend to pull away from the reader. _________________________

Which of the following is a method of entering functions?

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

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

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

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.

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

The ____ function determines the lowest number in a range.

You cannot format an entire column at once.

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 arithmetic operator, ^, directs Excel to perform the division operation.

The Accounting number format assigns a floating dollar sign. _________________________

The ____ function displays the highest value in a range.

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

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.

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

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

In the order of operations, the last operation Excel performs is ____________________.

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.