2. Correct the #DIV/0! errors in the worksheet as follows
Correct the #DIV/0! errors in the worksheet as follows:
a. Use Trace Precedents arrows to find the source of the #DIV/0! error in cell G12.
b. Correct the formula in cell G12, which should divide the remaining principal (cell G11) by the loan amount (cell D6) to find the percentage of remaining principal.
c. Fill the range H12:K12 with the formula in cell G12 to correct the remaining #DIV/0! errors.
d. Remove any remaining trace arrows.