Excel Module 2 Test Review Lesson

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Which of the following happens when you enter the formula =G15 into a cell?

The ____ function displays the highest value in a range.

The ____ function determines the lowest number in a range.

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

What is the default view in Excel called?

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

The equal sign (=) precedes a formula.

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

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

The range automatically selected by Excel is always correct.

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

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