Excel Formulas/Functions

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.

• So the calculation will be done last.

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.

• Look Up data

The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.

• total

• Sum

• percentage

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 before and after the cell reference letter.

• %

• $

• &

• #