a. Use the cell range A2:F8 to create a pivot table in cell H2. This pivot table will have three columns: job title, Average of Bonus % and the count of Employees for each Job Title. (Hint: Do not drop all the fields in Columns area) Edit the header of each column to show Job Title, Average Bonus %, Number of Employees. Format the Average of Bonus % as percentage with two decimal points.

b. Create a 3-D Pie pivot chart and place it in H8:M22 that illustrates the distribution of Average Bonus %, Number of Employees by Job Title. Ensure that each slice of the pie has a data label which shows both the category name and the percentage.

1 2 Name 3 Marie Roberto 4 Jimmy Wang 5 Jason Wills 6 Anne Harbor 7 Vivian O'Cornel 8 Mike Jackson 9 10 11 Performance Rating 12 Bonus Percentage 13 14 Compensation Job Tittle Performance Rating Salary Manager 4 $ 50,000 Manager 5 $ 55,000 Asst Manager 3 $ 35,000 Asst Manager 4 $ 40,000 Trainee 5 $ 20,000 Trainee 4 $ 22,000 Bonus % - 4.5% 7.0% 3.0% 4.5% 7.0% 4.5% Bonus Amount $2,250 $3,850 $1,050 $1,800 $1,400 $990 Bonus Lookup Table 1 2 3 4 5 0.0% 1.0% 3.0% 4.5% 7.0%