Excel Domain 5 Exam Review

Front

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

Back

20

Tags

5.1

Front

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

Back

=

Tags

5.1

Front

Which of the following operators is used for multiplication in Excel? * / > x

Back

*

Tags

5.1

Front

What does the acronym PEMDAS stand for in mathematics?

Back

Parenthesis, exponents, multiplication, division, addition, subtraction

Tags

5.1

Front

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

Back

No

Tags

5.1

Front

Which symbol is used to override the standard order of operations in mathematical expressions? ( ) , < > , @ , *

Back

( )

Tags

5.2

Front

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

Back

arithmetic operators

Tags

5.2

Front

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

Back

Show Formulas

Tags

5.2

Front

Back

/

Tags

5.2

Front

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

Back

absolute

Tags

5.3