Formulas in Excel

In the picture, why is D2 through D5 placed in paranthesis?

• So Excel knows to total the cells before performing the next operation.
• So the total of the cells can be multiplied rather than added.

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.

Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.

• True
• False

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

By default, all cell references are _________ references. 

• Absolute
• Relative

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. 

• %
• $
• &
• #

The LOOKUP function in Excel is used to search one column of data and find data in the _______ row

• Corresponding
• Value