Microsoft Excel Vocab Review

Freeze the tiles means Excel displays the titles on the screen no matter how far down or to the right your scroll.

• True

• False

Point mode allows you to select cells for use in a formula by using the mouse.

• True

• False

Absolute cell reference instructs Excel to keep the cell reference constant in the formula as it copies it to the destination area.

• True

• False

Fixed dollar sign is a dollar sign that appears immediately to the left of the first digit with no space.

• True

• False

Answer explanation

Correct definition: floating dollar sign

With conditional formatting, Excel lets you apply formatting that appears only when the value in a cell meets conditions that you specify.

• True

• False

A relational operator is a condition of less than or greater than in a condition statement.

• True

• False

Currency format sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.

• True

• False

Answer explanation

Correct definition: Average function

A fixed dollar sign is a dollar sign to the far left in the cell with spaces between it and the the first digit.

• True

• False

E-mail is the most popular service on the Internet electron transmission of message and files using the Internet.

• True

• False

Function take a value, performs an operation, and returns a result to the cell.

• True

• False