$1\mathrm{.}1$ In cell B$7,$ enter a formula to calculate the total interest paid over the life

of the loan $($the total payments $-$ the original price of the truck$).$ Use cell

references.

m$.$ Apply borders using the Thick Outside Borders option around cells

A$6$:B$7.$

n$.$ In cell A$9,$ type: Average sales

o$.$ In cell B$9,$ enter a formula to calculate the average sales per month for the

truck locations. Hint: Use cells B$7$:E$7$ from the MobileSales worksheet as the

function argument.

p$.$ Apply the Currency number format to cell B$9.$ Display two digits after the

decimal.

q$.$ In cell A$10,$ type: Buy new truck?

r$.$ In cell B$10,$ enter a formula using the IF function to display Yes if the

monthly payment for the truck loan is less than the average sales per month

for the current trucks. Display

No if it is not.

This workbook includes two worksheets for data from the Tysons store. You

should only be working with the latest data from $2019.$

a$.$ Hide the TysonsStore$2018$ worksheet.

Complete the following steps in the TysonsStore$2019$ worksheet:

a$.$ Select cells A$2$:A$32,$ and apply the Short Date date format.

b$.$ Find the top ten sales items for the month. Select cells B$2$:D$32$ and use

conditional formatting to apply a green fill with dark green text to the

top $10$ values.

c$.$ In cell F$2,$ 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 K$1.$ Use an absolute reference where appropriate and copy the

formula to cells F$3$:F$32.$

d$.$ In cell G$2,$ enter a formula using the IF function to determine whether

the daily sales goal in cell K$2$ was met. Display yes if the value in the Daily

Total $($$$)$ column is greater than or equal to the daily sales goal. Display

no if it is not. Use an absolute reference where appropriate and copy the

formula to cells G$3$:G$32.$

e$.$ Create a named range DailyTotals for cells F$2$:F$32.$

f$.$ In cell $K3,$ enter a formula using the named range DailyTotals to

calculate the average daily