Question: 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

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. HINT: create a pivot table for Sales Region, Product and Total Sales 4 Marks

Pivot Table 2. Also, the company is trying to establish the overall top performing sales representative. If you recall from the previous Excel assignment, 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). HINT: create a pivot table that will show Sales Person, Product and Total Sales. 4 Marks

Pivot Table 3. Finally, determine the top 2 saddles in each market. HINT: create a pivot table that will show Sales Regional, Product and Units Sold. 4 MarksYou must have a separate Pivot Table in it's own tab created for each of the 3 scenarious above.

To add a Pivot Table select the sales data and click on

Sales Person Diana Michacl es son Jake Mark Hannah Units sold 24 24 23 22 18 17 15 15 14 13 11 Anthony 3.5 23 21 21 20 Flirt Vinide Jason Shelby Zachary Meyre willic Rebecca Patrick Safiya Paul James Dominique Grant Steven Holly Courtney Larry Joremy jasmine Christopher Iesha Els Shanda Shona Mileah Hayden David Elizabeth Michael Jessica Zoc Kulim Harrison Samantha Krystyna Halle 18 18 18 13 13 9 25 22 17 14 11 9 9 7 5 5 20 19 18 18 17 16 15 14 14 14 14 Product Saddle 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 Sacie 1 Saddle 1 Pour 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 Sed 1 Saddle 1 Saddle Saddle 1 Saddle 1 add 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 S1 Saddle 1 Sad 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 1 Sad 1 Saddle 1 Saddle 1 Saddle 1 Saddic 1 Ford 1 Saddle 1 Saddle Saddle 1 Saddle 1 de 1 Saddle 1 Saddle 1 Saddle Saddle 1 Soul 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 S1 Saddle z Saddle 2 Saddle 2 Saddle 2 Saddle Saddie 2 Paddle Saddle 2 Saddle 2 Saddle 2 Saddle 2 Saddle Saddle 2 Saddle 2 Saddle 2 Saddle 2 Sad 2 Saddle z Saddle 2 Saddle Padom Saddle 2 God Saddle z Saddle 2 Saddle 2 Saddle 2 Sole Saddle 2 Saddle Seddie 2 Saddle 2 Sad Saddle 2 Saddle Saddle 2 Saddle 2 Saddle Saddle 2 Hannah Kellee Scylance Zechariah Cell Llizabeth Michael Jason Anthony Hannah Diana Shelt Zachary Mark Jason Vinkle Patrick Paul Holly Safiya 13 12 11 8 6 5 5 5 24 23 22 20 19 18 10 9 9 9 6 > $ 5 23 19 1 19 18 16 13 10 10 10 9 1 25 23 19 17 16 8 7 7 6 Dominique Willie James Rebecca May Steven Shan Jeremy Price $750.00 $50.00 $750.00 $750.00 $750.00 $750,00 $790.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750,00 $/30.00 $750.00 $750.00 $750.00 $750,00 9/30.00 $750.00 $750.00 $750.00 $750.00 $/30.00 $750.00 $750.00 $750,00 $750.00 $120.00 $750,00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $790.00 $750.00 $750.00 $750.00 $750.00 $0.00 SA5000 $80.00 $850.00 $850.00 $80.00 $850.00 $850.00 $850.00 4250.00 850.00 $850.00 $850.00 $850.00 S850.00 $850.00 $850.00 $850.00 $ $850.00 $850.00 $850.00 $850.00 $800.00 $850.00 $850.00 $ $850.00 1:50.00 $80.00 SAS0.00 $850.00 $850.00 $850.00 $820.00 $850.00 $850.00 $850.00 SASO.00 $850.00 $850.00 $850.00 wered S850.00 $850.00 $850.00 $850.00 $850.00 $850.00 $850.00 $850.00 SA50.00 $850.00 $ $950.00 $950.00 $950.00 $950.00 $900.00 $950.00 $950.00 $950.00 $950.00 $900.00 $950.00 $950.00 $950.00 $950.00 $900.00 $050.00 $950.00 $950.00 $950.00 $900.00 S050.00 SAR $950.00 $950.00 $950.00 $950.00 SO80.00 $950.00 $950.00 $950.00 $950.00 $950.00 $900.00 $950.00 $950.00 $950,00 $950.00 $900.00 $ 1960.00 $950.00 $950.00 $950.00 $900.00 S050.00 $950.00 $950.00 $950.00 $900.00 Stian $950.00 $950.00 Total Sales $23,750. $23,750.00 $22,800.00 $ $22,800.00 $22,800.00 $21,850.00 $21,850.00 $21,850.00 $21,850.00 $21,850.00 $21,250.00 $21,250.00 $20,900.00 $20,900.00 $20,400.00 $20,400.00 $19,950.00 $19,950.00 $19,550.00 $19,550,00 $19,550.00 $19,550.00 $19,550.00 $19,000.00 $18,750,00 $18,750.00 $18,700.00 $18,700.00 $ 1 $18,050.00 $18,050.00 $18,050.00 $18,000.00 $19,000.00 $17,250.00 $17,250.00 $17,000,00 $17,000.00 $17,000.00 $16,500.00 $ $16,500.00 $16,150.00 $16,150.00 $16,150.00 $16,150.00 $16,150.00 $16,150.00 $15,750.00 $15,750.00 $15,300.00 $15,300.00 $15,300.00 $15,300.00 $15,000.00 $15,000.00 $14,450.00 $14,450.00 $14,250.00 $14,250.00 $14,250.00 $14,250.00 $14,250.00 $13,500.00 $13,600.00 $13,500.00 $13,500.00 $13,500.00 tis $13,500.00 $13,500.00 $13,500.00 $13,500.00 $12,750.00 $12,750.00 $12.750,00 $12,350.00 $12,850.00 $12,350.00 $12,000.00 $11,900,00 $11,900.00 $11,400.00 $11,400.00 $11,400.00 $11,250.00 $11,250.00 $11.250.00 $11,050.00 $10,500.00 $10,500.00 $10,500.00 $10,500.00 $10,500.00 $10,500.00 $10,450.00 $10,450.00 $10,450.00 $10,450.00 $10,450.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,500.00 $9,500.00 $9,500.00 $9,000.00 $8,550.00 $8,500.00 $8,500.00 $8,500.00 $8,500.00 $8,250.00 $8,250,00 $3,250.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $ $7,650.00 $7,600.00 $7,500.00 $6,800.00 $6,750.00 $6.750.00 $6,650.00 $6,650.00 $6,650.00 $6,650.00 $6,650.00 $6,000.00 $6,000.00 $5,950.00 $5,950.00 $5,950.00 $5,700.00 $5,700.00 $5,700.00 9.00.0 $5,700.00 $5,250,00 $5,100.00 $5,100.00 $5,100.00 $4,500.00 $4,250,00 $4,250.00 $3,750.00 $3,750.00 $3,750.00 $8.750,00 =le 24 22 Shend Larry Courtney Christopher Jasmine FIS Cara Krystyna Elizabeth Hannah Milearn Tlayden David Harrison Halle Zoe Kolton Sh Kellec Rebecca Zechariah Seylance 23 22 20 20 19 18 18 17 16 Saddle 2 Saddle 2 Saddle 2 Saddle 2 Sed Saddle 2 Saddle 2 Saddle z Saddle 2 S Saddle z Saddle 3 Saddle 3 Saddle 14 14 9 S Michael Zachary Diana Miche Michael 9 9 6 23 22 19 19 15 13 12 11 10 Shelby Anthony Elizabeth Vinkle Mark Jason feke Hannah Grant RCA Saflys Holly James Paul Patrick Dominique Sivut Maya Willie Christopher Jasmine ny Lisa lesha Larry Shana Carry Shanda Scylence Krystyna Saddle 3 Saddle Saddle Seca Saddle 3 Saddle 3 Saddle Saddle 3 Saddle 3 Saddle 3 Ford Saddle 3 Saddle Saddle 3 Saddle Sounds Saddle Saddle 3 Saddle 3 Saddle 3 3 Saddle 3 Saddle 3 Saddle 3 Saddle 3 Sad 3 Saddle 3 Saddle 3 3 Saddle Saddle 3 Saddles Sade 3 Saddle 3 3 Saddle 3 Saddle 3 Saddle 3 S3 Saddle Saddle 3 Sade 3 Saddle 3 3 Saddle 3 Saddle 3 / 6 6 23 73 22 15 11 10 10 8 7 7 6 6 24 23 21 22 19 17 15 12 6 25 25 24 74 Milesh Samantha Harrison Hannah Halle David Tlayden Rete Jessica Cara Zoe Michael Kuliaan Zechariah Elizabeth 23 20 19 15 13 13 12 11 11 11 & 1 7 7 Sales Person Diana Michacl es son Jake Mark Hannah Units sold 24 24 23 22 18 17 15 15 14 13 11 Anthony 3.5 23 21 21 20 Flirt Vinide Jason Shelby Zachary Meyre willic Rebecca Patrick Safiya Paul James Dominique Grant Steven Holly Courtney Larry Joremy jasmine Christopher Iesha Els Shanda Shona Mileah Hayden David Elizabeth Michael Jessica Zoc Kulim Harrison Samantha Krystyna Halle 18 18 18 13 13 9 25 22 17 14 11 9 9 7 5 5 20 19 18 18 17 16 15 14 14 14 14 Product Saddle 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 Sacie 1 Saddle 1 Pour 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 Sed 1 Saddle 1 Saddle Saddle 1 Saddle 1 add 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 S1 Saddle 1 Sad 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 1 Sad 1 Saddle 1 Saddle 1 Saddle 1 Saddic 1 Ford 1 Saddle 1 Saddle Saddle 1 Saddle 1 de 1 Saddle 1 Saddle 1 Saddle Saddle 1 Soul 1 Saddle 1 Saddle 1 Saddle 1 Saddle 1 S1 Saddle z Saddle 2 Saddle 2 Saddle 2 Saddle Saddie 2 Paddle Saddle 2 Saddle 2 Saddle 2 Saddle 2 Saddle Saddle 2 Saddle 2 Saddle 2 Saddle 2 Sad 2 Saddle z Saddle 2 Saddle Padom Saddle 2 God Saddle z Saddle 2 Saddle 2 Saddle 2 Sole Saddle 2 Saddle Seddie 2 Saddle 2 Sad Saddle 2 Saddle Saddle 2 Saddle 2 Saddle Saddle 2 Hannah Kellee Scylance Zechariah Cell Llizabeth Michael Jason Anthony Hannah Diana Shelt Zachary Mark Jason Vinkle Patrick Paul Holly Safiya 13 12 11 8 6 5 5 5 24 23 22 20 19 18 10 9 9 9 6 > $ 5 23 19 1 19 18 16 13 10 10 10 9 1 25 23 19 17 16 8 7 7 6 Dominique Willie James Rebecca May Steven Shan Jeremy Price $750.00 $50.00 $750.00 $750.00 $750.00 $750,00 $790.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750,00 $/30.00 $750.00 $750.00 $750.00 $750,00 9/30.00 $750.00 $750.00 $750.00 $750.00 $/30.00 $750.00 $750.00 $750,00 $750.00 $120.00 $750,00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $790.00 $750.00 $750.00 $750.00 $750.00 $0.00 SA5000 $80.00 $850.00 $850.00 $80.00 $850.00 $850.00 $850.00 4250.00 850.00 $850.00 $850.00 $850.00 S850.00 $850.00 $850.00 $850.00 $ $850.00 $850.00 $850.00 $850.00 $800.00 $850.00 $850.00 $ $850.00 1:50.00 $80.00 SAS0.00 $850.00 $850.00 $850.00 $820.00 $850.00 $850.00 $850.00 SASO.00 $850.00 $850.00 $850.00 wered S850.00 $850.00 $850.00 $850.00 $850.00 $850.00 $850.00 $850.00 SA50.00 $850.00 $ $950.00 $950.00 $950.00 $950.00 $900.00 $950.00 $950.00 $950.00 $950.00 $900.00 $950.00 $950.00 $950.00 $950.00 $900.00 $050.00 $950.00 $950.00 $950.00 $900.00 S050.00 SAR $950.00 $950.00 $950.00 $950.00 SO80.00 $950.00 $950.00 $950.00 $950.00 $950.00 $900.00 $950.00 $950.00 $950,00 $950.00 $900.00 $ 1960.00 $950.00 $950.00 $950.00 $900.00 S050.00 $950.00 $950.00 $950.00 $900.00 Stian $950.00 $950.00 Total Sales $23,750. $23,750.00 $22,800.00 $ $22,800.00 $22,800.00 $21,850.00 $21,850.00 $21,850.00 $21,850.00 $21,850.00 $21,250.00 $21,250.00 $20,900.00 $20,900.00 $20,400.00 $20,400.00 $19,950.00 $19,950.00 $19,550.00 $19,550,00 $19,550.00 $19,550.00 $19,550.00 $19,000.00 $18,750,00 $18,750.00 $18,700.00 $18,700.00 $ 1 $18,050.00 $18,050.00 $18,050.00 $18,000.00 $19,000.00 $17,250.00 $17,250.00 $17,000,00 $17,000.00 $17,000.00 $16,500.00 $ $16,500.00 $16,150.00 $16,150.00 $16,150.00 $16,150.00 $16,150.00 $16,150.00 $15,750.00 $15,750.00 $15,300.00 $15,300.00 $15,300.00 $15,300.00 $15,000.00 $15,000.00 $14,450.00 $14,450.00 $14,250.00 $14,250.00 $14,250.00 $14,250.00 $14,250.00 $13,500.00 $13,600.00 $13,500.00 $13,500.00 $13,500.00 tis $13,500.00 $13,500.00 $13,500.00 $13,500.00 $12,750.00 $12,750.00 $12.750,00 $12,350.00 $12,850.00 $12,350.00 $12,000.00 $11,900,00 $11,900.00 $11,400.00 $11,400.00 $11,400.00 $11,250.00 $11,250.00 $11.250.00 $11,050.00 $10,500.00 $10,500.00 $10,500.00 $10,500.00 $10,500.00 $10,500.00 $10,450.00 $10,450.00 $10,450.00 $10,450.00 $10,450.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,500.00 $9,500.00 $9,500.00 $9,000.00 $8,550.00 $8,500.00 $8,500.00 $8,500.00 $8,500.00 $8,250.00 $8,250,00 $3,250.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $7,650.00 $ $7,650.00 $7,600.00 $7,500.00 $6,800.00 $6,750.00 $6.750.00 $6,650.00 $6,650.00 $6,650.00 $6,650.00 $6,650.00 $6,000.00 $6,000.00 $5,950.00 $5,950.00 $5,950.00 $5,700.00 $5,700.00 $5,700.00 9.00.0 $5,700.00 $5,250,00 $5,100.00 $5,100.00 $5,100.00 $4,500.00 $4,250,00 $4,250.00 $3,750.00 $3,750.00 $3,750.00 $8.750,00 =le 24 22 Shend Larry Courtney Christopher Jasmine FIS Cara Krystyna Elizabeth Hannah Milearn Tlayden David Harrison Halle Zoe Kolton Sh Kellec Rebecca Zechariah Seylance 23 22 20 20 19 18 18 17 16 Saddle 2 Saddle 2 Saddle 2 Saddle 2 Sed Saddle 2 Saddle 2 Saddle z Saddle 2 S Saddle z Saddle 3 Saddle 3 Saddle 14 14 9 S Michael Zachary Diana Miche Michael 9 9 6 23 22 19 19 15 13 12 11 10 Shelby Anthony Elizabeth Vinkle Mark Jason feke Hannah Grant RCA Saflys Holly James Paul Patrick Dominique Sivut Maya Willie Christopher Jasmine ny Lisa lesha Larry Shana Carry Shanda Scylence Krystyna Saddle 3 Saddle Saddle Seca Saddle 3 Saddle 3 Saddle Saddle 3 Saddle 3 Saddle 3 Ford Saddle 3 Saddle Saddle 3 Saddle Sounds Saddle Saddle 3 Saddle 3 Saddle 3 3 Saddle 3 Saddle 3 Saddle 3 Saddle 3 Sad 3 Saddle 3 Saddle 3 3 Saddle Saddle 3 Saddles Sade 3 Saddle 3 3 Saddle 3 Saddle 3 Saddle 3 S3 Saddle Saddle 3 Sade 3 Saddle 3 3 Saddle 3 Saddle 3 / 6 6 23 73 22 15 11 10 10 8 7 7 6 6 24 23 21 22 19 17 15 12 6 25 25 24 74 Milesh Samantha Harrison Hannah Halle David Tlayden Rete Jessica Cara Zoe Michael Kuliaan Zechariah Elizabeth 23 20 19 15 13 13 12 11 11 11 & 1 7 7

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Instructions Start Excel. Download and open the file named Exp19_Excel_Ch05_ML1_RealEstate.xlsx. Grader has automatically added your last name to the beginning of the filename. Before subtotaling the...

Download spreadsheet CaseSalesData-998acc.xlsx pivot table please help! Sales Data Completing this activity will help you learn to: 1. use Excel to determine sales by date, by product, by involce, by...

Transaction ID Product Category Date Sales Revenue Cost 1 0 0 1 Electronics 2 0 2 1 - 0 1 - 0 5 $ 1 , 2 0 0 . 0 0 $ 3 0 0 . 0 0 1 0 0 2 Clothing 2 0 2 1 - 0 1 - 0 8 $ 4 5 0 . 0 0 $ 5 0 . 0 0 1 0 0 3...

Create the following graphics on new tabs: 1 . Use filters or a pivot table to cull the data necessary to construct a vertical frequency bar graph to display the number of applicants in each category...

I need help with capestone project for financial accounting 2 Account \& Unadjusted TB data Journal Entry data A B. C D E F G H BA212 Financial Accounting II Capstone Project Adjusting lournal...

Ch 11 excel exercise Open the Problem_Data_CH11.xlsx EXCEL workbook. Review the four worksheets, then a create table for the data in each worksheet (Hint: Insert > Tables > Table. Name each table the...

g. h. Add the profit by category and quarter. Format the data in currency format. Add meaningful column labels. Format the title at the top so it stands out. Add a meaningful title to the worksheet...

. Data collected from the survey as below . . Question: Please do the statistical Analysis and descriptive analysis through SPSS. i need to do as soon as possible? if you can also use the formula in...

000000000000n0000000+0m0000000 i fx 2.4"LCD Touch screen, 8GB flash memorv, plays music, video, photos and text, share IPEG, EMP, GIf, Tiff Iuctio Productlabel ProductName File Home Insert Page...

11)For a presentation, you want to sort customer orders for the quarter from largest to smallest, and also highlight orders that are larger than the average order amount. How will you accomplish it?...

A brokerage company is interested in forecasting the number of new accounts the office will obtain next month. It has collected the following data for the past 12 months: MonthAccounts 1.19 2.20 3.21...

1. Consturct the normal form of this matrix 2. How would the game look if Strategy R was removed? for each value of x, find the equilibria of the game. 3. What values of x makes R played with...

The minimum amount tequired for a federal diversity lawsuit is

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".