a$.$ In cell B$16,$ enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan for Year $1($payment $1$ in cell B$14$ through payment $12$ in cell B$15).$ Use $0$ as the type argument in your formula because payments are made at the end of the period.

b$.$ Use absolute references for the rate, nper, and pv arguments, which are listed in the range C$4$:C$10.$

c$.$ Use relative references for the start and end arguments.

d$.$ Fill the range C$16$:K$16$ with the formula in cell B$16$ to calculate the interest paid in Years $210$ and the total interest.