Excel hw
Pmnguyen1989
spreadsheet_activity_9.xlsxSorting & Filtering
| 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 |
Sorting and filtering It is relatively simple to use the sorting and filtering tools within spreadsheets. In some spreadsheets, there are buttons on toolbars that will automatically sort and/or filter for you. However, in most, you can use the menu to find how use these tools. Look up how to use them to filter and sort this data and find the following answers. Who sold the most units of Saddle 3? (Hint: filter Saddle 3 and then sort Units Sold from highest to lowest to find the highest performing sales representative. If there is a tie, use a secondary sort to sort total sales second to see who, of those who sold the most units, sold the most units and the highest total dollar sales. If there is still a tie, see if you can figure out a way to determine (using the filtering and sorting tools) to determine which one of them actually sold the most in sales dollars of all products (Saddle 1, Saddle 2, and Saddle 3). Next, go to the Tables page for more work.
Tables
| 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 |
| 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 |
| West | Zachary | 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 |
| Northeast | Jasmine | Saddle 3 | 23 | $950.00 | $21,850.00 |
| Midwest | Samantha | Saddle 3 | 23 | $950.00 | $21,850.00 |
| Northeast | Shana | Saddle 2 | 25 | $850.00 | $21,250.00 |
| Midwest | Cara | Saddle 2 | 25 | $850.00 | $21,250.00 |
| West | Diana | Saddle 3 | 22 | $950.00 | $20,900.00 |
| South | Safiya | Saddle 3 | 22 | $950.00 | $20,900.00 |
| West | Elizabeth | Saddle 2 | 24 | $850.00 | $20,400.00 |
| Midwest | Krystyna | Saddle 2 | 24 | $850.00 | $20,400.00 |
| Northeast | Jeremy | Saddle 3 | 21 | $950.00 | $19,950.00 |
| Northeast | Elsa | Saddle 3 | 21 | $950.00 | $19,950.00 |
| West | Michael | Saddle 2 | 23 | $850.00 | $19,550.00 |
| South | Patrick | Saddle 2 | 23 | $850.00 | $19,550.00 |
| Northeast | Jeremy | 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 |
| Midwest | Harrison | Saddle 3 | 20 | $950.00 | $19,000.00 |
| South | Maya | Saddle 1 | 25 | $750.00 | $18,750.00 |
| Northeast | Courtney | Saddle 1 | 25 | $750.00 | $18,750.00 |
| West | Jason | Saddle 2 | 22 | $850.00 | $18,700.00 |
| Midwest | Mileah | Saddle 2 | 22 | $850.00 | $18,700.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 |
| West | Diana | Saddle 1 | 24 | $750.00 | $18,000.00 |
| West | Michael | Saddle 1 | 24 | $750.00 | $18,000.00 |
| West | Jason | Saddle 1 | 23 | $750.00 | $17,250.00 |
| South | Willie | Saddle 1 | 23 | $750.00 | $17,250.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 |
| West | Jake | Saddle 1 | 22 | $750.00 | $16,500.00 |
| Northeast | Larry | Saddle 1 | 22 | $750.00 | $16,500.00 |
| West | Hannah | Saddle 2 | 19 | $850.00 | $16,150.00 |
| South | Paul | 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 |
| Northeast | Larry | Saddle 3 | 17 | $950.00 | $16,150.00 |
| Midwest | Harrison | Saddle 2 | 19 | $850.00 | $16,150.00 |
| South | Rebecca | Saddle 1 | 21 | $750.00 | $15,750.00 |
| South | Patrick | Saddle 1 | 21 | $750.00 | $15,750.00 |
| West | Diana | Saddle 2 | 18 | $850.00 | $15,300.00 |
| South | Safiya | Saddle 2 | 18 | $850.00 | $15,300.00 |
| Midwest | Halle | Saddle 2 | 18 | $850.00 | $15,300.00 |
| Midwest | Zoe | Saddle 2 | 18 | $850.00 | $15,300.00 |
| South | Safiya | Saddle 1 | 20 | $750.00 | $15,000.00 |
| Midwest | Mileah | Saddle 1 | 20 | $750.00 | $15,000.00 |
| Northeast | Shanda | Saddle 2 | 17 | $850.00 | $14,450.00 |
| Midwest | Kolton | Saddle 2 | 17 | $850.00 | $14,450.00 |
| West | Shelby | 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 |
| Midwest | Hayden | Saddle 1 | 19 | $750.00 | $14,250.00 |
| Midwest | Halle | Saddle 3 | 15 | $950.00 | $14,250.00 |
| South | Grant | Saddle 2 | 16 | $850.00 | $13,600.00 |
| Northeast | Larry | Saddle 2 | 16 | $850.00 | $13,600.00 |
| Midwest | Samantha | Saddle 2 | 16 | $850.00 | $13,600.00 |
| West | Mark | 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 |
| South | Dominique | Saddle 1 | 18 | $750.00 | $13,500.00 |
| Midwest | David | Saddle 1 | 18 | $750.00 | $13,500.00 |
| Midwest | Elizabeth | Saddle 1 | 18 | $750.00 | $13,500.00 |
| West | Hannah | Saddle 1 | 17 | $750.00 | $12,750.00 |
| Northeast | Jeremy | Saddle 1 | 17 | $750.00 | $12,750.00 |
| Midwest | Michael | Saddle 1 | 17 | $750.00 | $12,750.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 |
| Midwest | Jessica | Saddle 1 | 16 | $750.00 | $12,000.00 |
| Midwest | Kellee | Saddle 2 | 14 | $850.00 | $11,900.00 |
| Midwest | Rebecca | Saddle 2 | 14 | $850.00 | $11,900.00 |
| West | Elizabeth | Saddle 3 | 12 | $950.00 | $11,400.00 |
| Northeast | Courtney | Saddle 3 | 12 | $950.00 | $11,400.00 |
| Midwest | Rebecca | Saddle 3 | 12 | $950.00 | $11,400.00 |
| West | Anthony | Saddle 1 | 15 | $750.00 | $11,250.00 |
| West | Elizabeth | Saddle 1 | 15 | $750.00 | $11,250.00 |
| Midwest | Zoe | Saddle 1 | 15 | $750.00 | $11,250.00 |
| South | Dominique | Saddle 2 | 13 | $850.00 | $11,050.00 |
| West | Vinkle | Saddle 1 | 14 | $750.00 | $10,500.00 |
| Northeast | Jasmine | Saddle 1 | 14 | $750.00 | $10,500.00 |
| Midwest | Kolton | 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 | Vinkle | Saddle 3 | 11 | $950.00 | $10,450.00 |
| South | James | Saddle 3 | 11 | $950.00 | $10,450.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 |
| West | Jason | Saddle 1 | 13 | $750.00 | $9,750.00 |
| South | Grant | Saddle 1 | 13 | $750.00 | $9,750.00 |
| South | Steven | Saddle 1 | 13 | $750.00 | $9,750.00 |
| Midwest | Halle | Saddle 1 | 13 | $750.00 | $9,750.00 |
| West | Mark | Saddle 3 | 10 | $950.00 | $9,500.00 |
| South | Paul | Saddle 3 | 10 | $950.00 | $9,500.00 |
| South | Patrick | Saddle 3 | 10 | $950.00 | $9,500.00 |
| Midwest | Rebecca | Saddle 1 | 12 | $750.00 | $9,000.00 |
| Midwest | Michael | Saddle 3 | 9 | $950.00 | $8,550.00 |
| West | Shelby | Saddle 2 | 10 | $850.00 | $8,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 1 | 11 | $750.00 | $8,250.00 |
| Northeast | Christopher | Saddle 1 | 11 | $750.00 | $8,250.00 |
| Midwest | Hannah | Saddle 1 | 11 | $750.00 | $8,250.00 |
| West | Zachary | Saddle 2 | 9 | $850.00 | $7,650.00 |
| West | Mark | Saddle 2 | 9 | $850.00 | $7,650.00 |
| South | Maya | 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 |
| Midwest | Jessica | Saddle 2 | 9 | $850.00 | $7,650.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 |
| South | Holly | Saddle 1 | 9 | $750.00 | $6,750.00 |
| Northeast | Iesha | Saddle 1 | 9 | $750.00 | $6,750.00 |
| West | Jason | Saddle 3 | 7 | $950.00 | $6,650.00 |
| South | Steven | Saddle 3 | 7 | $950.00 | $6,650.00 |
| South | Maya | Saddle 3 | 7 | $950.00 | $6,650.00 |
| Midwest | Zechariah | Saddle 3 | 7 | $950.00 | $6,650.00 |
| Midwest | Elizabeth | Saddle 3 | 7 | $950.00 | $6,650.00 |
| West | Zachary | Saddle 1 | 8 | $750.00 | $6,000.00 |
| Midwest | Kellee | Saddle 1 | 8 | $750.00 | $6,000.00 |
| South | Steven | Saddle 2 | 7 | $850.00 | $5,950.00 |
| Northeast | Christopher | Saddle 2 | 7 | $850.00 | $5,950.00 |
| Northeast | Jasmine | Saddle 2 | 7 | $850.00 | $5,950.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 |
| Northeast | Shanda | Saddle 3 | 6 | $950.00 | $5,700.00 |
| Northeast | Elsa | Saddle 1 | 7 | $750.00 | $5,250.00 |
| West | Jake | Saddle 2 | 6 | $850.00 | $5,100.00 |
| Northeast | Elsa | Saddle 2 | 6 | $850.00 | $5,100.00 |
| Midwest | Michael | 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 |
| Northeast | Shanda | Saddle 1 | 5 | $750.00 | $3,750.00 |
| Northeast | Shana | Saddle 1 | 5 | $750.00 | $3,750.00 |
| Midwest | Zechariah | Saddle 1 | 5 | $750.00 | $3,750.00 |
| Midwest | Cara | Saddle 1 | 5 | $750.00 | $3,750.00 |
| total row | 2255 | $1,915,050.00 |
Tables You will find that a table will do everything you just completed in the filtering and sorting activity on the sheet before. However, it sets everything up automatically and gives you the option of adding a total row at the bottom. This allows you to select different types of calculatiosn to automatically show up. Typically, the options include several of the functions you have learned so far such as Count, CountIF, Sum, Average, Min, Max, and even a few statistical calculations you haven't seen yet such as standard deviation. For this exercise, complete the following. 1. Insert the data into a table and have the table add a total row. 2. In the Total row under the Total Sales column, have the cell calculate by the Sum. 3. In the Total row under the Units sold column, have the cell calculate by sum. You will also change this to average during the activity. 4. Once again, sort the data greatest to least according to the Total Sales column. 5. Filter the data by Scylance and Krystyna. 6. What is their Total Combined Sales? 7. Filter just Krystyna and write down her total Units sold and Total Sales. 8. Filter just Scylance and write down his tolal Units sold and Total Sales. 9. Find the Total Sales for the entire Midwest and compare this to the Total Sales for e South.
