Excel Domain 5 Exam Review

Calculate the result of the following expression: (3 + 9) * 2 - 8 / 2

• 3

• 5

• 15

• 20

Tags

5.1

In Excel, which operator is used to initiate a formula?

• *

• /

• =

• $

Tags

5.1

Which of the following operators is used for multiplication in Excel?

• *

• /

• >

• x

Tags

5.1

What does the acronym PEMDAS stand for in mathematics?

• Parenthesis, explanations, multiplication, division, addition, subtraction

• Parenthesis, exponents, multiplication, division, addition, subtraction

• Parents, exponents, multiplication, division, addition, subtraction

• Parents, exponents, multiplication, doublecheck, addition, subtraction

Tags

5.1

Does the formula =6*2/3 yield the same result as =6*(2/3)?

• Yes

• No

Tags

5.1

Which of the following symbols is used to override the standard order of operations in mathematical expressions?

• ( )

• < >

• @

• *

Tags

5.2

In Excel, the +, -, *, and / are all examples of _________________________.

• PEMDAS

• arithmetic operators

• functions

• symbols

Tags

5.2

To view all the formulas in a worksheet, which command should you select from the ribbon?

• Show Functions

• Show Operators

• Show Data

• Show Formulas

Tags

5.2

Which of the following operators is used for division in Excel?

• /

• <

• =

Tags

5.2

To ensure a cell reference remains constant when copying or moving it within a formula, you should use a(n) _________________________ cell reference.

• relative

• mixed

• linked

• absolute

Tags

5.3