$\backslash$table$[[$Steps$,$Pivot Table Exercise,,,$],[1,$Using the data on the right, create a pivot table,,,$]]$

Set the Pivot table to have the months in the rows and the years in the columns. The date in the table is the actual sales.

Put Years in the Columns

Rows Months

Sum of Actual Sales

$2$ Add column of average monthly sales

$3$ Create a pivot chart

Add title

$x$ and $Y$ Axis

And the linear line and equation, for all lines

$4$ Add average columns for months and years

Questions

$1$ What is the grand total for March?

$2$ What is the Grand total for $2021?$

$3$ What is the Grand Total?

$4$ What is the intercept for the line for $2021?$

$5$ What is the slope for the line for $2022?$

$6$ Uploade your pivot chart