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 B enter a formula to calculate the total interest paid over the life of the loan the total payments in cell B the original price of the truck in cell B Use cell references.
e Apply borders using the Thick Outside Borders option around cells A:B
Complete the following steps in the TysonsStore worksheet:
a In cell F 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 I Use an absolute reference where appropriate and copy the formula to cells F:F
b In cell enter a formula to calculate the average daily sales in dollars.
c In cell enter a formula to find the lowest daily sales in dollars.
d In cell enter a formula to find the highest daily sales in dollars.
Save and close the workbook.
Upload and save your project file.
Submit project for grading.
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
