Payments on a loan are usually made monthly. True False 2.The data table is one of a group of Excel's What-If Analysis tools. True False 3.

1.Payments on a loan are usually made monthly.

True

False

2.The data table is one of a group of Excel's What-If Analysis tools.

True

False

3.A ________ is a list of values that are acceptable for a range of cells.

validation list

data table

table array

cell range

4.Present value (Pv) represents the amount of the loan before any payments are made.

True

False

5.When you use a defined name in a(n) ________, the result is the same as if you typed the cell reference.