. Spa 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 20. Add another level to the Rows, and include Classification. 2d. Format the Pivot Table so that it is easy to read (and professional). 13. Create a PivotChart Pie Chart for Revenue by location. 2 3 4 Paradise Lakes Resort Revenue by Employee, Location, and Category 5 6 Name Classification Location Category Amoun Target Increases 7 BJ Francine Representative Baudette Rentals $ 17,000 27 $178,857 8 Alec Mikayla Representative Baudette Rentals $ 17,000 37 $180,611 9 Mikayla Anderson Representative Baudette Excursions $ 3,400 47 $182,364 10 Ella Jamison Manager Baudette Excursions $ 2,700 11 David Gazik Manager Baudette Boutique $ 1.200 12 Natasha Ari Associate Baudette $ 4,500 13 Ari Aronson Associate Baudette Boutique $ 3,200 14 Dennis Frankie Representative Breezy Point Rentals $ 18,000 15 Kendal Shaedon Associate Breezy Point Spa $ 4,800 16 Frankie Dennis Representative Breezy Point Excursions $ 7,500 17 Kendra Shelton Representative Breezy Point Rentals $ 8,500 18 DJ Bushman Representative Breezy Point Boutique $ 1200 19 Sharon Wyatte Manager Breezy Point Rentals $ 5,000 20 Suzanne Ouimet Manager 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 Manager Cass Lake Rentals $ 15,000 24 Christopher Bowman Manager Cass Lake Boutique $ 3,700 25 Jeffery Dalton Representative Cass Lake Rentals $ 3,700 26 Corey Daniels Associate Cass Lake Excursions $ 4,500 27 Randy Josephson Associate Cass Lake Boutique $ 1.500 28 Tammy Christine Representative Walker Rentals $ 17,500 29 Josie Daddiline Representative Walker Rentals $ 12,000 30 Nikolai Jalowiec Manager Walker Boutique $ 1.450 31 Lilly Oliver Associate Walker Spa $ 2.200 32 Jeanie Dennis Associate Walker Excursions $ 3,800 33 Total 26 $ 175, 350 34 . Spa 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 20. Add another level to the Rows, and include Classification. 2d. Format the Pivot Table so that it is easy to read (and professional). 13. Create a PivotChart Pie Chart for Revenue by location. 2 3 4 Paradise Lakes Resort Revenue by Employee, Location, and Category 5 6 Name Classification Location Category Amoun Target Increases 7 BJ Francine Representative Baudette Rentals $ 17,000 27 $178,857 8 Alec Mikayla Representative Baudette Rentals $ 17,000 37 $180,611 9 Mikayla Anderson Representative Baudette Excursions $ 3,400 47 $182,364 10 Ella Jamison Manager Baudette Excursions $ 2,700 11 David Gazik Manager Baudette Boutique $ 1.200 12 Natasha Ari Associate Baudette $ 4,500 13 Ari Aronson Associate Baudette Boutique $ 3,200 14 Dennis Frankie Representative Breezy Point Rentals $ 18,000 15 Kendal Shaedon Associate Breezy Point Spa $ 4,800 16 Frankie Dennis Representative Breezy Point Excursions $ 7,500 17 Kendra Shelton Representative Breezy Point Rentals $ 8,500 18 DJ Bushman Representative Breezy Point Boutique $ 1200 19 Sharon Wyatte Manager Breezy Point Rentals $ 5,000 20 Suzanne Ouimet Manager 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 Manager Cass Lake Rentals $ 15,000 24 Christopher Bowman Manager Cass Lake Boutique $ 3,700 25 Jeffery Dalton Representative Cass Lake Rentals $ 3,700 26 Corey Daniels Associate Cass Lake Excursions $ 4,500 27 Randy Josephson Associate Cass Lake Boutique $ 1.500 28 Tammy Christine Representative Walker Rentals $ 17,500 29 Josie Daddiline Representative Walker Rentals $ 12,000 30 Nikolai Jalowiec Manager Walker Boutique $ 1.450 31 Lilly Oliver Associate Walker Spa $ 2.200 32 Jeanie Dennis Associate Walker Excursions $ 3,800 33 Total 26 $ 175, 350 34