Excel Lesson 4 Review

All formulas begin with an ____

• * sign

• = sign

• - sign

• + sign

An operand is a constant or cell reference used in formula.

• True

• False

An absolute reference does not change if the formula is copied or moved.

• True

• False

In a formula, operations within parentheses are performed after operations outside parentheses.

• True

• False

Which cell reference adjusts to its new location if the formula is copied or moved.

• Absolute

• Mixed

• Relative

Formulas can have only one operator.

• True

• False

Sum Button is located on the Home Tab in the Number Group.

• True

• False

The results of the calculation appear in the formula bar.

• True

• False

Worksheet formulas consist of two components: operands and operators.

• True

• False

If two or more operators have the same order of evaluation, the equation is evaluated from left to right.

• True

• False