Question: Go to the Business Customer Analysis worksheet, which compiles data about the Texas business accounts that Kamal handles. Calculate the number of years a customer

Go to the Business Customer Analysis worksheet, which compiles data about the Texas business accounts that Kamal handles. Calculate the number of years a customer has been with Cello Worldwide as follows:
a. In cell E5, enter a formula without using a function that subtracts the start date for the customer from the current date and divides the result by 365.25, the number of days in a year, accounting for leap year.
b. Use an absolute reference to cell C2 in the formula.
c. Display the value in cell E5 with one decimal place.
d. Fill the range E6:E18 with the formula in cell E5.
Go to the Business Customer Analysis worksheet,

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!