Excel Formulas/Functions

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

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

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.

• %

• $

• &

• #

When calculating the tax per item the formula to use it

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

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 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

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

• Absolute
• relative

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

• Absolute
• Relative

The most common way to identify a cell reference is 

• $D2
• $D$2
• D$2
• D2$

The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.

• range containing data
• Price of the item being looked for