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 H use the Error Checking command to identify the error in the cell.b Correct the error to total the values in the range C: In a later step, you will calculate the interest and principal in the range C: to remove the remaining errors Correct the #VALUE! errors in the worksheet as follows:a Use Trace Precedents arrows to find the source of the #VALUE! error in cell Cb Correct the formula in cell C which should divide the remaining principal cell C by the loan amount cell D to find the pensentage of remaining principal.CFill the range D: with the formula in cell C to correct the remaining#VALUE! errors.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
