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

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.

$17.$ Make a copy of the OnlineSales worksheet and name it PivotData $.$ The PivotData worksheet should be the last worksheet in the workbook.

$18.$ Go to the OnlineSales worksheet and format the sa$\text{'}$

Aqua, Table Style Light $9.$

Reset Progress $$ Back to top $\frac{?}{\text{b}\text{a}\text{r}}()$

$19.$ Display the table Total row.

a$.$ Display the total for the Quantity column.