Question: hello can I please get help with #9 and #12 on this assignment! od AaBbccc AaBbCD AaBbCcDd AaBbcc AaBb CcDc AaBbCcDc AaBDCDC A Subtitle 1

od AaBbccc AaBbCD AaBbCcDd AaBbcc AaBb CcDc AaBbCcDc AaBDCDC A Subtitle 1 Title 11 No Spac... Subtle Em... Intense E... Quote Intense Q... Sut Styles der - Instructions Step Instructions You now need to add a few summary measures for upper management. Add the following on the Payroll worksheet. In cell J1, add a function that calculates the total Net Payroll Increase based on the Raise Amt in cell range J6 J13. In cell J2, add a function that calculates the Average Raise % based on the Final % Increase in cell range K6 K13 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 ads to start at a Minimum bound of 0.01for 1% Change the decimal places of the vertical axis numbers to O 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 coll 26 Set the chart title to 11 pt font If necessary, set the vertical and horizontalis labels to 9pt font 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 cel A22 Copy the formula through cell 324 to determine the number of employees earning the Standard and Low raises In 27, to sum the total raise amount earned, enter a formula to sun the Raise Amt in cel range J6313 the anteca AZT is met Use absolute references when necessary. Copy the formula through celi B2 Save and close Excel_BU02 Assessment 2_Raises i directed EX Excel Submit the file as Total Plants Painted Paradise Today's Date 2/25/2020 High Bonus Low Deducts Net Payroll increase Average Rased Raise Standard Employed 5 s kate Munson 6 Meda Rodate 7 Christyistas 8 Jason Niese 9 Poul Medina 10 Juanita Gomes 11 Susan Brock 12 Jay Groth 13 Kate Munson HireDate lob Title Salary 114/2010 Spa Manager 71.500 /12/2009 Therapist $42.100 0/12/2009 Massage Therapist L asertherapists 45.000 2/1/2011 Coffee Shop Manager $15.000 /1/2007 Barista 515/2010 Gift Shop Manage 1/16/2007 Sales Associate 6/4/2005 Sale
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
