Excel Lesson 4 Quiz

What is one of the essential elements of Excel that enables you to perform calculations?

• Cell reference

• Constant

• Arithmetic operator

• Formula

Which of the following is calculated first according to the order of operations?

• 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

What is an example of an absolute cell reference?

• A9

• A$9

• $A$9

• A9:E9

What is an example of a mixed cell reference?

• A9

• A$9

• $A$9

• A9:E9

True or False: All formulas in Excel begin with an equal sign (=).

• True

• False

True or False: In a school competition, Ethan, Arjun, and Mia are participating in an Excel challenge. The scope of a named range is the location within which Excel recognizes the name without qualification.

• True

• False

True or False: In a school project, Ethan, Aiden, and Scarlett are working on a spreadsheet. They want to create a new range by selecting the cells and typing a name in the Name Box next to the formula bar. Is it possible?

• True

• False

True or False: In a mathematics class, the order of operations determines which parts of a problem are solved before other parts of the problem.

• True

• False

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

• True

• False