Excel Module 4 Vocab Review

Front

Beginning and ending balances of a loan, with payments applied to principal and interest.

Back

Amortization Schedule

Front

Ensures users don't change critical worksheet values

Back

Cell Protection

Front

Examines formulas in a workbook like a spell checker for misspelled words

Back

Formulas Checker

Front

Created from a column name and a row title

Back

Cell Name

Front

Calculates loan payment based on constant payments and interest rate

Back

PMT Function

Front

Future value of an investment based on scheduled payments and a constant interest rate

Back

FV Function

Front

A range of cells showing formula-generated answers with substituted values.

Back

Data Table

Front

Varies value in one cell to see effect on formulas

Back

One-Input Data Table

Front

Present value of an annuity

Back

PV Function

Front

Fixed payments at the end of periods with fixed interest rate

Back

Annuity