FUNCTIONS

For Functions, describe what the function does, give its syntax, describe its inputs, and whether the inputs are required or optional.

Example: PMT Function

The PMT Function is a financial function that calculates the payment for a loan based on constant payments and a constant interest rate. The formula syntax is PMT(rate, nper, pv, [fv], [type]).

Rate is the interest rate for the loan. Required.

Nper is the total number of payments for the loan. Required.

Pv is the present value. Required.

[Fv] is the future value. Optional.

[Type] indicates when the payments are due. Optional.

DEFINITIONS

For Definitions, describe what happens when the cell is copied and filled to other cells. Give an example.

Example:

Relative cell reference. Relative cell references change when a formula is copied or filled to another cell. An example of a relative cell reference is A1.

Functions (2 points each)

1. VLOOKUP

2. SUMIF

Definitions (1 point each)

3. Absolute Cell References

4. Mixed Cell References