sales in dollars.

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 $K7.$ Accept the solution found by

Goal Seek.

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

Make a copy of the OnlineSales worksheet and name it PivotData $.$

The PivotData worksheet should be the last worksheet in the workbook.

$$ Go to the OnlineSales worksheet and format the sales data as a table

using the table style

Aqua, Table Style Light $9.$

Display the table Total row.

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

b$.$ Remove the count from the State column.

$$ Sort the data alphabetically by values in the Item column.

$$ Filter the table to show only rows where the value in the State column is

MD$.$

$$ Create a PivotTable using the data in cells A$3$:D$120$ from the data in the

PivotData worksheet. The PivotTable should appear on its own worksheet.

Use values from the Item column as the rows and the sum of values in the

Quantity column as the values.

$$ Name the PivotTable worksheet: PivotTable It should be located to

the left of the PivotData worksheet.

$$ Insert a PivotChart on the PivotTable worksheet. Use a pie chart to

represent the total quantity

for each item. If necessary, move the PivotChart to the right of the PivotTable

so it does not cover the data.

This workbook includes a hidden worksheet with online sales data from the

$2018$ buy one get one free sale.

a$.$ Unhide the BOGOSale$2018$ worksheet.

$$ Save and close the workbook.