Quizziz Game - Excel Lesson 4 - 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

True or False?  To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

• True
• False
• N/A
• N/A

True or False?  Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

• True
• False
• N/A
• N/A

True or 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
• N/A
• N/A

True or False?  The order of operations determines which parts of a formula are calculated before other parts of the formula.

• True
• False
• N/A
• N/A

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

• True
• False
• N/A
• N/A