Help excel

Pivot Table Project 1. Download the “Pivot Table Data” file. 2. Save it as PivotTableYourName.xlsx. 3. Attach the completed file.

Question 1 – Create a pivot table that answers this question.

What are the total number of units sold for each item per rep?

Sort the total from highest to lowest

Name the sheet Question 1

Question 2 – Create a pivot table that answers this question.

What are the total sales for each rep?

On the same sheet, create a bar chart

Name the sheet Question 2

Question 3 – Create a pivot table that answers this question.

What are the total number of items sold per region?

Filter to show binders and pencils only

Name the sheet Question 3

Task Points Question 1 – complete pivot table Sort total highest to lowest

8 2

Question 2 – complete pivot table Bar Chart

10 5

Question 3 – complete pivot table Filter

9 3

File and Sheets named correctly 3 Total 40