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 $F3FF2.$

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 K$3,$ enter a formula using the named range DailyTotals to calculate the average daily sales in dollars.

g$.$ In cell K$4,$ enter a formula using the named range DailyTotals to find the lowest daily sales