Create a PivotTable to

Create a PivotTable to

Create a PivotTable to

$1\mathrm{.}5$ Create a PivotTable to examine which product sales are seasonal.

a$.$ Create a PivotTable on the ProductSalesByDate worksheet to answer the question, "Which of the products have sales that are seasonal?"

b$.$ Show total product sales by date for each product.

c$.$ Expand year to quarter and quarter to month to show sales by year, quarter, and month.

d$.$ Remove the display of the Year Subtotals from the PivotTable.

e$.$ Create a Line PivotChart from the PivotTable report to see the change in values over time.

f$.$ Click on the collapse entire field button and then the expand button to see how the PivotChart changes. $+/-$ buttons in the bottom right corner of