Excel Lesson 4

Which of the following is not an arithmetic operator?

• +
• -
• *
• ]

Which of the following is an example of an absolute 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

Excel recognizes 3 + 4 = as a legitimate formula.

• True
• False

You  cannot use a named range in a formula that references another worksheet.

• 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