Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

13. 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

13. 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.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question