The original price of a car is entered into spreadsheet cell A1 and the length of time

Question:

The original price of a car is entered into spreadsheet cell A1 and the length of time it takes to totally depreciate is entered into cell B1.
a. Write the spreadsheet formula that calculates the amount that the car depreciates each year.
b. The spreadsheet user is instructed to enter a length of time in years that is within the car's lifetime in cell C1. Write the spread- sheet formula that will calculate the car's value after that period of time.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: