Module 2 Excel Test Review

A ____ is a prewritten formula that is built into Excel.

• function
• feature
• task
• calculation

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

• placement
• operations
• positioning
• selections

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

• Excel recalculates all formulas in the worksheet
• Excel assigns the sum of the values in the previous 15 cells to the active cell
• Excel assigns the value in cell G15 to the active cell
• Nothing; =G15 is an invalid formula

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

• related
• relative
• pasted
• alternative

The ____ function displays the highest value in a range.

• MIN
• SUM
• MAX
• AVERAGE

The ____ function determines the lowest number in a range.

• LOW
• BASE
• LEAST
• MIN

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.

• DIVSUM
• RANGEAVG
• AVERAGE
• MAX

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

• Formula Finder
• Range Finder
• Calculation Finder
• Function Finder

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

• Comma style format
• Accounting number format
• Percent style format
• Currency style format

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

• header
• topper
• margin
• crown