$4$ You would like to calculate the total number of payment periods for each loan. To complete the task, you will use a mixed cell reference as an alternative to an absolute cell reference.

Enter a formula in cell H$8$ to calculate the total number of payment periods per loan. Use an appropriate mixed cell reference for cell B$5$ and then use the fill handle to copy the formula down, completing column H$.8$