TERM

DEFINITION

TERM AS IT RELATES TO YOU OR YOUR EXPERIENCE

PMT function (EX 242)

The PMT function calculates the payment for a loan based on constant payments and a constant interest rate. The payment returned by PMT includes principal and interest but none of the taxes, reserve payments, or fees that sometimes are associated with loans.

data table (EX 242, EX 257)

amortization schedule (EX 242, EX 266)

Liquidating a debt by installment payments is referred to as amortizing.

PV function (EX 242, EX 268)

cell protection (EX 244)

(sometimes called unlocked cells)

(sometimes called locked cells)

formula checker (EX 244)

Similar to a spell checker for words, a formula checker is used for the checking formulas for rule violations.

hiding (portions of a workbook) (EX 244)

Allows specific interaction with specific portions of worksheets.

hyperlink (EX 244)

Advance to other webpages or websites.

name (for a cell) (EX 251)

A label to reference a cell in a formula.

global (EX 252)

A nature of names.

label (EX 253)

Labels are relative references.

input value (EX 257)

Is the specific interest rate used to calculate the assenting figures in a in an amortization schedule.

one-input data table (EX 257)

two-input data table (EX 257)

annuity (EX 268)

An annuity is a series of fixed payments at a fixed interest rate made over a continuous period. Examples of annuities include car loans and mortgages.

protected cells (EX 286)

(sometimes called locked cells)

unprotected cells (EX 286)

(sometimes called unlocked cells)

password (EX 288)

A password can be up to 255 characters (letters, numbers, or symbols) and is case-sensitive. Although good passwords are obscure, it is important that they be memorable.

background formula checking (EX 292)