Question: d . In cell B 7 , enter a formula to calculate the total interest paid over the life of the loan ( the total

d. In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments in cell B6- the original price of the truck in cell B1). Use cell references.
e. Apply borders using the Thick Outside Borders option around cells A6:B7.
14. Complete the following steps in the TysonsStore2019 worksheet:
a. In cell F2, enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total (# Sold) column by the current price per box in cell I1. Use an absolute reference where appropriate and copy the formula to cells F3:F31.
b. In cell 13, enter a formula to calculate the average daily sales in dollars.
c. In cell 14, enter a formula to find the lowest daily sales in dollars.
d. In cell 15, enter a formula to find the highest daily sales in dollars.
15. Save and close the workbook.
16. Upload and save your project file.
17. Submit project for grading.
 d. In cell B7, enter a formula to calculate the total

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 Databases Questions!