Question: a . In cell H 1 7 , use the Error Checking command to identify the error in the cell.b . Correct the error to

a. In cell H17, use the Error Checking command to identify the error in the cell.b. Correct the error to total the values in the range C17:17. In a later step, you will calculate the interest and principal in the range C17:18 to remove the remaining errors.2. Correct the #VALUE! errors in the worksheet as follows:a. Use Trace Precedents arrows to find the source of the #VALUE! error in cell C20.b. Correct the formula in cell C20, which should divide the remaining principal (cell C19) by the loan amount (cell D5) to find the pensentage of remaining principal.C.Fill the range D20:20 with the formula in cell C20 to correct the remaining#VALUE! errors.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!