EXCEL FORMULAS POP QUIZ

If the parenthesis is removed, what will 9.5% be multiplied by? 

• D2 +D3+D4+D5
• D5
• D2
• None

Which response best completes the following statement: A formula is used to 

• perform calculations or other actions.
• find averages.

Excel follows the ___________________ and first adds the values inside the parentheses.

• Order of Operations
• Formula Guidelines

___________ are often the best way to define which calculations will be performed first in Excel.

• Parentheses
• Forumlas

Unlike _________ references, _________ references do not change when copied or filled. 

• Absolute, Relative
• Relative, Absolute

An absolute reference is designated in a formula by the addition of a _______ sign. 

• %
• $
• &
• #

If you don't want a cell reference to change when copied to other cells, use _________ references

• Absolute
• relative

Which symbol must all formula begin with?

• =
• +
• (
• @

* is a symbol for:

• Multiplication

• Addition

• Subtraction

• Dividing

What is the reference of the active cell?

• g15

• H19

• B21

• V11

• a17