Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started