1. With the Table below, sort by Name, and then by Classification. 2. Use the Table on the REVENUE worksheet to create a Pivot Table in a new worksheet. 2a. Give the new worksheet a name. 2b. Location should be the Rows in the table, and your values should be the Count of Employees and Sum of Revenue 2c. Add another level to the Rows, and include Classification. 2d. Format the PivotTable so that it is easy to read (and professional). 3. Create a PivotChart Pie Chart for Revenue by location

Q e Share 0 Comments L M N Rentals AutoSave OFF HESUS Class_16_-_Word_Problems_on_Pivot_Tables Student_Copy (1) Home Insert Draw Page Layout Formulas Data Review View Tell me A1 x fe 1. With the Table below, sort by Name, and then by Classification. A D E F H Revenue by Employee, Location, and Category S S 6 Name Classification Location Category Amount Target Increases 7 BJ Francine Representative Baudette Rentals s 17,000 24 $178,857 8 Alec Mikayla Representative Baudette 17,000 346 $160,611 9 Mikayla Anderson Representative Baudette Excursions 3,400 $182,964 10 Ella Jamison Manager Baudette Excursions 2,700 11 David Gazik Manager Baudette Boutique $ 1,200 12 Natasha Ari Associate Baudette Spa 4.500 13 Ari Aronson Associate Baudette Boutique $ 3,200 14 Dennis Frankie Representative Breezy Point Rentals 5 18,000 15 Kendal Shaedon Associate Breezy Point Spa s 4.800 16 Frankie Dennis Representative Breezy Point Excursions 7.500 17 Kendra Shelton Representative Breezy Point Rentals 8,500 18 DJ Bushrnan Representative Breezy Point Boutique $ 1,209 19 Sharon Wyatte Manager Breezy Point Rentals 5 5.000 20 Suzanne Ouimet Manage Breezy Point Spa 2,500 21 Chad Mei Representative Cass Lake Excursions $ 10,000 22 Mae Gomez Representative Cass Lake Spa 3.500 23 Christopher Bowman Cass Lake Rentals $ 15,000 24 Christopher Bowman Cass Lake Boutique 5 3.700 25 Jeffery Dalton Representative Cass Lake Rentals s 3.700 26 Corey Daniels Associate Cass Lake Excursions $ 4.500 27 Randy Josephson Associate Cass Lake Boutique 1,500 28 Terry Christine Representative Rentals 17.500 29 Josie Daddiline Representative Walker Rentals 5 s 12,000 30 Nikolai Jaloviec Manager Walker Boutique 1,450 31 Lilly Oliver Associate Walker Spa $ 2,200 32 Jeanie Dennis Associate Walker Excursions 3.800 33 Total 26 $325.350 34 $ Manager Manager Walker $ $ 35 36 37 38 Revenue + El 100%