a) Use the cell range A2:F8 to create a pivot table in cell H2. This pivot table will have three columns: have Job Title as rows, show the Average of Bonus % and the count of Name (use Name field to count this) 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. (15 points) b) Create a 3-D Pie pivot chart and place it in H8:M22 that illustrates the distribution of Average Bonus %, Number of Employee. Ensure that each slice of the pie has a data label which shows both the category name and the percentage. (8 points) Nmm 3 B D E G Compensation Job Tittle Manager Manager Asst Manager Asst Manager Trainee Trainee Performance RatinSalary 4 $ 50,000 5 5 55,000 3 $ 35,000 4 $ 40,000 5 $ 20,000 4 5 22,000 Bonus % 4.5% 7.0% 3.0% 4.5% 7.0% 4.5% Bosus Amount $2,250 53,850 $1,050 $1,800 $1,400 $990 1 Bonus Lookup Table 2 1,0% 4 5 3 3.0% 0.0% 4.5% 7.0% 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 15 16 17 18 19 20 21 22 23 24 25 26 a) Use the cell range A2:F8 to create a pivot table in cell H2. This pivot table will have three columns: have Job Title as rows, show the Average of Bonus % and the count of Name (use Name field to count this) 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. (15 points) b) Create a 3-D Pie pivot chart and place it in H8:M22 that illustrates the distribution of Average Bonus %, Number of Employee. Ensure that each slice of the pie has a data label which shows both the category name and the percentage. (8 points) Nmm 3 B D E G Compensation Job Tittle Manager Manager Asst Manager Asst Manager Trainee Trainee Performance RatinSalary 4 $ 50,000 5 5 55,000 3 $ 35,000 4 $ 40,000 5 $ 20,000 4 5 22,000 Bonus % 4.5% 7.0% 3.0% 4.5% 7.0% 4.5% Bosus Amount $2,250 53,850 $1,050 $1,800 $1,400 $990 1 Bonus Lookup Table 2 1,0% 4 5 3 3.0% 0.0% 4.5% 7.0% 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 15 16 17 18 19 20 21 22 23 24 25 26