Question 5

You are creating a table showing the monthly payment on a house, comparing 15-year, 20-year, and 30-year mortgages at a variety of interest rates. Which of the following elements of the formula should use mixed cell references?

a. The length of the mortgage

b. The interest rates

c. The amount financed

d. Both the interest rates and the length of the mortgages

The purpose of the fill handle is to:

a. fill a range of cells with zeroes (00000) to indicate that data is missing.

b. copy a selected range of cells to an adjacent cell range.

c. fill a cell with pound signs (#######) to indicate the column width must be changed.

d. delete the contents of a cell.