Question: 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
Pivot Table Exercise 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 Add column of average monthly sales Create a pivot chart Add title X and Y Axis And the linear line and equation, for all lines Add average columns for months and years Questions What is the grand total for March? What is the Grand total for What is the Grand Total? What is the intercept for the line for What is the slope for the line for Uploade your pivot chart
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
