1. On the Payroll worksheet, based on the data in cell ranges A5:A13 and K5:K13, add a 3-D Clustered Column. Under chart styles, set the chart to Style 3. Change the vertical axis to start at a Minimum bound of 0.01for 1%. Change the decimal places of the vertical axis numbers to 0 Change the title to read Final % Increase Comparison Move and resize the chart so the upper-left corner is in cell F15 and the lower-right corner is in cell L26. Set the chart title to 11 pt font. If necessary, set the vertical and horizontal axis labels to 9 pt font.

2. In cell B22, to determine the number of employees earning the "High" raise, you will count cell range F6:F13 if they meet the criteria in cell A22. Copy the formula through cell B24 to determine the number of employees earning the Standard and Low raises.

G6 fix A B D G H J K M N O 1 E Today's Date High Bonus Low Deduct Painted Paradise F 2/21/2021 750 500 Net Payroll Increase Average Raise % 2 $ $ 3 RESORT & SPA 4 Salary $ 71,500 $ 42,100 $ 45,800 $ 35,000 $ 29,900 $ 37,200 $ 28,100 $ 28,700 Years Employed #NUM! 107 108 111 #VALUE! #VALUE! #VALUE! #VALUE! Raise Standard Recommend Raise % High Standard Standard High Standard Low Low Standard Low Final % New High Bonus Deduction Raise Amt Increase Salary #NUM! $ $ $ $ $ $ $ 5 Name HireDate Job Title 6 Meda Rodate 3/14/2010 Spa Manager 7 Christy Istas 8/12/2009 Therapist 8 Jason Niese 8/12/2009 Massage Therapist 9 Paul Medina 2/1/2011 Coffee Shop Manager 10 Juanita Gomez 9/30/2007 Barista 11 Susan Brock 5/15/2010 Gift Shop Manager 12 Jay Groth 3/16/2007 Sales Associate 13 Kate Munson 6/4/2005 Sales Associate 14 Standard 15 Years Employed Raise % 16 0 2.50% 17 2 3.00% 18 5 3.50% 19 7 4.00% 20 21 Raise Count 22 High 23 Standard 24 Low 25 26 Raise Amount Total 27 High 28 Standard 29 Low 30 31 32 Evaluations Payroll Edit G6 fix A B D G H J K M N O 1 E Today's Date High Bonus Low Deduct Painted Paradise F 2/21/2021 750 500 Net Payroll Increase Average Raise % 2 $ $ 3 RESORT & SPA 4 Salary $ 71,500 $ 42,100 $ 45,800 $ 35,000 $ 29,900 $ 37,200 $ 28,100 $ 28,700 Years Employed #NUM! 107 108 111 #VALUE! #VALUE! #VALUE! #VALUE! Raise Standard Recommend Raise % High Standard Standard High Standard Low Low Standard Low Final % New High Bonus Deduction Raise Amt Increase Salary #NUM! $ $ $ $ $ $ $ 5 Name HireDate Job Title 6 Meda Rodate 3/14/2010 Spa Manager 7 Christy Istas 8/12/2009 Therapist 8 Jason Niese 8/12/2009 Massage Therapist 9 Paul Medina 2/1/2011 Coffee Shop Manager 10 Juanita Gomez 9/30/2007 Barista 11 Susan Brock 5/15/2010 Gift Shop Manager 12 Jay Groth 3/16/2007 Sales Associate 13 Kate Munson 6/4/2005 Sales Associate 14 Standard 15 Years Employed Raise % 16 0 2.50% 17 2 3.00% 18 5 3.50% 19 7 4.00% 20 21 Raise Count 22 High 23 Standard 24 Low 25 26 Raise Amount Total 27 High 28 Standard 29 Low 30 31 32 Evaluations Payroll Edit