L04 Using Basic Formulas

Which of the following is not an arithmetic operator?

• +

• -

• *

• ]

Per the order of operations, which of the following is calculated first?

• Addition (+) and subtraction (−) (left to right)

• Exponentiation (ˆ)

• Percent (%)

• Negative number (−)

Which of the following is an acceptable name for a named range?

• C7

• subtotal_west

• subtotal west

• subtotal/west

Which of the following is an example of an absolute cell reference?

• A9

• A$9

• $A$9

• A9:E9

Which of the following is an example of a mixed cell reference?

• A9

• A$9

• $A$9

• A9:E9

To allow Excel to distinguish formulas from data, all formulas begin with an

equal sign (=).

• TRUE

• FALSE

Regarding a named range, the scope of a name is the location within which

Excel recognizes the name without qualification.

• TRUE

• FALSE

You can create a new range by selecting the cells and typing a name in the

Name Box next to the formula bar.

• TRUE

• FALSE

The order of operations determines which parts of a formula are calculated

before other parts of the formula.

• TRUE

• FALSE

The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3).

• TRUE

• FALSE