Excel Formulas/Functions

By default, all cell references are _________ references. 

• Absolute
• Relative

Generally speaking, the total from the sales tax formula  represents

• The total of the cells (rows or columns) being calculated
• The total of sales tax being calculated

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.

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

• %

• $

• &

• #

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

• Order of Operations
• Formula Guidelines

In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.

• relative
• relational

When calculating the tax per item the formula to use it

• = Total * sales tax%
• = Total +(Total * sales tax%)

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

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

The LookUp function has three arguments. First ___________ then data to search and finally, results column

• Value to Look Up
• Value to Calculate

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

• Absolute
• relative