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, per, and pv arguments, which are listed in the range C$4$: C$10.$C$.$d$.$Use relative references for the start and end arguments.Fill the range C$16$: K$16$ with the formula in cell B$16$ to calculate the interest paid in Years $2-10$ and the total interest.