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 $F3$:$F32.$

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 in dollars.

h$.$ In cell K$5,$ enter a formula using the named range DailyTotals to find the highest daily sales in dollars.

i$.$ Wrap the text in cell $J7.$

j$.$ Use Goal Seek to find the new price per box $($cell K$8)$ to reach a new daily average sales goal of $$3,000$ in cell K$7.$ Accept the solution found by Goal Seek.

k$.$ Modify cell $K8$ to show two places after the decimal.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 $F3$:$F32.$

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 in dollars.

h$.$ In cell K$5,$ enter a formula using the named range DailyTotals to find the highest daily sales in dollars.

i$.$ Wrap the text in cell $J7.$

j$.$ Use Goal Seek to find the new price per box $($cell K$8)$ to reach a new daily average sales goal of $$3,000$ in cell K$7.$ Accept the solution found by Goal Seek.

k$.$ Modify cell $K8$ to show two places after the decimal.