Excel hw
Pmnguyen1989
spreadsheet_activity_10.xlsxPivot Table Data
| Sales Region | Sales Person | Product | Units sold | Price | Total Sales | |
| Midwest | Scylance | Saddle 3 | 25 | $950.00 | $23,750.00 | |
| Midwest | Krystyna | Saddle 3 | 25 | $950.00 | $23,750.00 | |
| Midwest | Cara | Saddle 2 | 25 | $850.00 | $21,250.00 | |
| Northeast | Shana | Saddle 2 | 25 | $850.00 | $21,250.00 | |
| South | Maya | Saddle 1 | 25 | $750.00 | $18,750.00 | |
| Northeast | Courtney | Saddle 1 | 25 | $750.00 | $18,750.00 | |
| Northeast | Christopher | Saddle 3 | 24 | $950.00 | $22,800.00 | |
| Midwest | Mileah | Saddle 3 | 24 | $950.00 | $22,800.00 | |
| Midwest | Kellee | Saddle 3 | 24 | $950.00 | $22,800.00 | |
| Midwest | Krystyna | Saddle 2 | 24 | $850.00 | $20,400.00 | |
| West | Elizabeth | Saddle 2 | 24 | $850.00 | $20,400.00 | |
| West | Diana | Saddle 1 | 24 | $750.00 | $18,000.00 | |
| West | Michael | Saddle 1 | 24 | $750.00 | $18,000.00 | |
| West | Zachary | Saddle 3 | 23 | $950.00 | $21,850.00 | |
| Northeast | Jasmine | Saddle 3 | 23 | $950.00 | $21,850.00 | |
| South | Grant | Saddle 3 | 23 | $950.00 | $21,850.00 | |
| South | Rebecca | Saddle 3 | 23 | $950.00 | $21,850.00 | |
| Midwest | Samantha | Saddle 3 | 23 | $950.00 | $21,850.00 | |
| Northeast | Jeremy | Saddle 2 | 23 | $850.00 | $19,550.00 | |
| South | Patrick | Saddle 2 | 23 | $850.00 | $19,550.00 | |
| West | Michael | Saddle 2 | 23 | $850.00 | $19,550.00 | |
| Midwest | Elizabeth | Saddle 2 | 23 | $850.00 | $19,550.00 | |
| Midwest | Hannah | Saddle 2 | 23 | $850.00 | $19,550.00 | |
| West | Jason | Saddle 1 | 23 | $750.00 | $17,250.00 | |
| South | Willie | Saddle 1 | 23 | $750.00 | $17,250.00 | |
| South | Safiya | Saddle 3 | 22 | $950.00 | $20,900.00 | |
| West | Diana | Saddle 3 | 22 | $950.00 | $20,900.00 | |
| West | Jason | Saddle 2 | 22 | $850.00 | $18,700.00 | |
| Midwest | Mileah | Saddle 2 | 22 | $850.00 | $18,700.00 | |
| Northeast | Larry | Saddle 1 | 22 | $750.00 | $16,500.00 | |
| West | Jake | Saddle 1 | 22 | $750.00 | $16,500.00 | |
| Northeast | Jeremy | Saddle 3 | 21 | $950.00 | $19,950.00 | |
| Northeast | Elsa | Saddle 3 | 21 | $950.00 | $19,950.00 | |
| South | Rebecca | Saddle 1 | 21 | $750.00 | $15,750.00 | |
| South | Patrick | Saddle 1 | 21 | $750.00 | $15,750.00 | |
| Midwest | Harrison | Saddle 3 | 20 | $950.00 | $19,000.00 | |
| West | Anthony | Saddle 2 | 20 | $850.00 | $17,000.00 | |
| Midwest | Hayden | Saddle 2 | 20 | $850.00 | $17,000.00 | |
| Midwest | David | Saddle 2 | 20 | $850.00 | $17,000.00 | |
| South | Safiya | Saddle 1 | 20 | $750.00 | $15,000.00 | |
| Midwest | Mileah | Saddle 1 | 20 | $750.00 | $15,000.00 | |
| West | Michael | Saddle 3 | 19 | $950.00 | $18,050.00 | |
| West | Jason | Saddle 3 | 19 | $950.00 | $18,050.00 | |
| Northeast | Iesha | Saddle 3 | 19 | $950.00 | $18,050.00 | |
| Midwest | Hannah | Saddle 3 | 19 | $950.00 | $18,050.00 | |
| Midwest | Harrison | Saddle 2 | 19 | $850.00 | $16,150.00 | |
| South | Paul | Saddle 2 | 19 | $850.00 | $16,150.00 | |
| West | Hannah | Saddle 2 | 19 | $850.00 | $16,150.00 | |
| South | Holly | Saddle 2 | 19 | $850.00 | $16,150.00 | |
| Northeast | Iesha | Saddle 2 | 19 | $850.00 | $16,150.00 | |
| Midwest | Hayden | Saddle 1 | 19 | $750.00 | $14,250.00 | |
| Midwest | Halle | Saddle 2 | 18 | $850.00 | $15,300.00 | |
| Midwest | Zoe | Saddle 2 | 18 | $850.00 | $15,300.00 | |
| South | Safiya | Saddle 2 | 18 | $850.00 | $15,300.00 | |
| West | Diana | Saddle 2 | 18 | $850.00 | $15,300.00 | |
| Midwest | David | Saddle 1 | 18 | $750.00 | $13,500.00 | |
| Midwest | Elizabeth | Saddle 1 | 18 | $750.00 | $13,500.00 | |
| South | Paul | Saddle 1 | 18 | $750.00 | $13,500.00 | |
| South | James | Saddle 1 | 18 | $750.00 | $13,500.00 | |
| West | Mark | Saddle 1 | 18 | $750.00 | $13,500.00 | |
| South | Dominique | Saddle 1 | 18 | $750.00 | $13,500.00 | |
| Northeast | Larry | Saddle 3 | 17 | $950.00 | $16,150.00 | |
| Northeast | Shanda | Saddle 2 | 17 | $850.00 | $14,450.00 | |
| Midwest | Kolton | Saddle 2 | 17 | $850.00 | $14,450.00 | |
| Midwest | Michael | Saddle 1 | 17 | $750.00 | $12,750.00 | |
| West | Hannah | Saddle 1 | 17 | $750.00 | $12,750.00 | |
| Northeast | Jeremy | Saddle 1 | 17 | $750.00 | $12,750.00 | |
| Midwest | Samantha | Saddle 2 | 16 | $850.00 | $13,600.00 | |
| South | Grant | Saddle 2 | 16 | $850.00 | $13,600.00 | |
| Northeast | Larry | Saddle 2 | 16 | $850.00 | $13,600.00 | |
| Midwest | Jessica | Saddle 1 | 16 | $750.00 | $12,000.00 | |
| Midwest | Halle | Saddle 3 | 15 | $950.00 | $14,250.00 | |
| South | Holly | Saddle 3 | 15 | $950.00 | $14,250.00 | |
| Northeast | Shana | Saddle 3 | 15 | $950.00 | $14,250.00 | |
| West | Shelby | Saddle 3 | 15 | $950.00 | $14,250.00 | |
| Midwest | Zoe | Saddle 1 | 15 | $750.00 | $11,250.00 | |
| West | Anthony | Saddle 1 | 15 | $750.00 | $11,250.00 | |
| West | Elizabeth | Saddle 1 | 15 | $750.00 | $11,250.00 | |
| Midwest | Kellee | Saddle 2 | 14 | $850.00 | $11,900.00 | |
| Midwest | Rebecca | Saddle 2 | 14 | $850.00 | $11,900.00 | |
| Midwest | Kolton | Saddle 1 | 14 | $750.00 | $10,500.00 | |
| West | Vinkle | Saddle 1 | 14 | $750.00 | $10,500.00 | |
| Northeast | Jasmine | Saddle 1 | 14 | $750.00 | $10,500.00 | |
| Midwest | Harrison | Saddle 1 | 14 | $750.00 | $10,500.00 | |
| Midwest | Samantha | Saddle 1 | 14 | $750.00 | $10,500.00 | |
| Midwest | Krystyna | Saddle 1 | 14 | $750.00 | $10,500.00 | |
| West | Anthony | Saddle 3 | 13 | $950.00 | $12,350.00 | |
| Midwest | David | Saddle 3 | 13 | $950.00 | $12,350.00 | |
| Midwest | Hayden | Saddle 3 | 13 | $950.00 | $12,350.00 | |
| South | Dominique | Saddle 2 | 13 | $850.00 | $11,050.00 | |
| West | Jason | Saddle 1 | 13 | $750.00 | $9,750.00 | |
| South | Grant | Saddle 1 | 13 | $750.00 | $9,750.00 | |
| Midwest | Halle | Saddle 1 | 13 | $750.00 | $9,750.00 | |
| South | Steven | Saddle 1 | 13 | $750.00 | $9,750.00 | |
| West | Elizabeth | Saddle 3 | 12 | $950.00 | $11,400.00 | |
| Midwest | Rebecca | Saddle 3 | 12 | $950.00 | $11,400.00 | |
| Northeast | Courtney | Saddle 3 | 12 | $950.00 | $11,400.00 | |
| Midwest | Rebecca | Saddle 1 | 12 | $750.00 | $9,000.00 | |
| Midwest | Jessica | Saddle 3 | 11 | $950.00 | $10,450.00 | |
| Midwest | Cara | Saddle 3 | 11 | $950.00 | $10,450.00 | |
| Midwest | Zoe | Saddle 3 | 11 | $950.00 | $10,450.00 | |
| South | James | Saddle 3 | 11 | $950.00 | $10,450.00 | |
| West | Vinkle | Saddle 3 | 11 | $950.00 | $10,450.00 | |
| Midwest | Hannah | Saddle 1 | 11 | $750.00 | $8,250.00 | |
| Northeast | Christopher | Saddle 1 | 11 | $750.00 | $8,250.00 | |
| West | Shelby | Saddle 1 | 11 | $750.00 | $8,250.00 | |
| South | Paul | Saddle 3 | 10 | $950.00 | $9,500.00 | |
| West | Mark | Saddle 3 | 10 | $950.00 | $9,500.00 | |
| South | Patrick | Saddle 3 | 10 | $950.00 | $9,500.00 | |
| South | Willie | Saddle 2 | 10 | $850.00 | $8,500.00 | |
| South | James | Saddle 2 | 10 | $850.00 | $8,500.00 | |
| South | Rebecca | Saddle 2 | 10 | $850.00 | $8,500.00 | |
| West | Shelby | Saddle 2 | 10 | $850.00 | $8,500.00 | |
| Midwest | Michael | Saddle 3 | 9 | $950.00 | $8,550.00 | |
| South | Maya | Saddle 2 | 9 | $850.00 | $7,650.00 | |
| West | Zachary | Saddle 2 | 9 | $850.00 | $7,650.00 | |
| Midwest | Zechariah | Saddle 2 | 9 | $850.00 | $7,650.00 | |
| Midwest | Scylance | Saddle 2 | 9 | $850.00 | $7,650.00 | |
| West | Mark | Saddle 2 | 9 | $850.00 | $7,650.00 | |
| Midwest | Jessica | Saddle 2 | 9 | $850.00 | $7,650.00 | |
| Northeast | Iesha | Saddle 1 | 9 | $750.00 | $6,750.00 | |
| South | Holly | Saddle 1 | 9 | $750.00 | $6,750.00 | |
| South | Dominique | Saddle 3 | 8 | $950.00 | $7,600.00 | |
| Midwest | Kolton | Saddle 3 | 8 | $950.00 | $7,600.00 | |
| Northeast | Courtney | Saddle 2 | 8 | $850.00 | $6,800.00 | |
| West | Zachary | Saddle 1 | 8 | $750.00 | $6,000.00 | |
| Midwest | Kellee | Saddle 1 | 8 | $750.00 | $6,000.00 | |
| Midwest | Zechariah | Saddle 3 | 7 | $950.00 | $6,650.00 | |
| West | Jason | Saddle 3 | 7 | $950.00 | $6,650.00 | |
| South | Steven | Saddle 3 | 7 | $950.00 | $6,650.00 | |
| Midwest | Elizabeth | Saddle 3 | 7 | $950.00 | $6,650.00 | |
| South | Maya | Saddle 3 | 7 | $950.00 | $6,650.00 | |
| Northeast | Christopher | Saddle 2 | 7 | $850.00 | $5,950.00 | |
| South | Steven | Saddle 2 | 7 | $850.00 | $5,950.00 | |
| Northeast | Jasmine | Saddle 2 | 7 | $850.00 | $5,950.00 | |
| Northeast | Elsa | Saddle 1 | 7 | $750.00 | $5,250.00 | |
| Northeast | Shanda | Saddle 3 | 6 | $950.00 | $5,700.00 | |
| West | Jake | Saddle 3 | 6 | $950.00 | $5,700.00 | |
| West | Hannah | Saddle 3 | 6 | $950.00 | $5,700.00 | |
| South | Willie | Saddle 3 | 6 | $950.00 | $5,700.00 | |
| West | Jake | Saddle 2 | 6 | $850.00 | $5,100.00 | |
| Midwest | Michael | Saddle 2 | 6 | $850.00 | $5,100.00 | |
| Northeast | Elsa | Saddle 2 | 6 | $850.00 | $5,100.00 | |
| Midwest | Scylance | Saddle 1 | 6 | $750.00 | $4,500.00 | |
| West | Jason | Saddle 2 | 5 | $850.00 | $4,250.00 | |
| West | Vinkle | Saddle 2 | 5 | $850.00 | $4,250.00 | |
| Midwest | Zechariah | Saddle 1 | 5 | $750.00 | $3,750.00 | |
| Northeast | Shanda | Saddle 1 | 5 | $750.00 | $3,750.00 | |
| Midwest | Cara | Saddle 1 | 5 | $750.00 | $3,750.00 | |
| Northeast | Shana | Saddle 1 | 5 | $750.00 | $3,750.00 |
To add a Pivot Table select the sales data and click on "Pivot Table" in the bar above. You may have to firstselect the data and then click "data" to get the Pivot Table button to show up. This will most likely insert a table on another sheet and bring up the options box. Do this for each of the assignments below. Rename each sheet to match the activity. Pivot Table 1. Imagine that your boss has asked you to find the Sum of Total Sales for each product (Saddle 1, Saddle 2, and Saddle 3) by region. Pivot Table 2. Also, the company is trying to establish the overall top performing sales representative. If you recall from Activity 9, Scylance and Krystyna were the top by total sales. How does this break down by product? The previous activity only sorted by total sold (by product). With this in mind, do you think someone else could be the top seller? Pivot Table 3. Finally, determine the top 2 saddles in each market.
