Thank you in Advance

1. EmployeesWorksheet

Summary Informationa) Complete the "Summary Information" box, using names and appropriateConditional Math andStatisticalfunctions. No marks ifthesefunctions are not used.

Calculate Witholding Taxb) After defining appropriate range names, use them in a formula in range F5:F34 that will calculate Witholding Tax for employees using the tax rates indicated in the "Witholding Tax Rates" box.

Witholding tax is based on Salary.c) Insert the list of range names in the "Range Names" box.

AutoSave OFF ACCT 150-RNB_Excel Exam_F2020 Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 AA ab Wrap Text v General LIX V V 4 Paste BIUV DVAv E Merge & Center v $ ~ % " 00 -20 Conditional Format Cell Insert Delete Format Sort & Find 8 Ideas Formatting as Table Styles Filter Select J7 fx A B C D E F G H K L M N 0 P Q R JOUIDWN Peel Manufacturing Withholding Tax Rates Employee Withholding FT Employees with at least 1 Dependant 7% FT Employees with no Dependants 5% Employee ID Name Hire Date Status Dependants Salary Withholding Tax All other employees with or without dependants 3% 7276 Amisha 2007-10-18 FT 4 90,21 9858 Arshdeep 2018-11-07 PT UI HUI AN 18 ,984 Summary Information 8936 Avneet 2014-06-16 FT 42,906 Number of FT Employees 6881 Bilikis 2020-03-09 FT 37,191 Average Salary of FT Employees 852 Chisom 2009-12-14 FT 52,528 Average Salary of FT Employees with at least 1 Dependant 10 Christiani 2014-06-05 PT 17,12 Average Salary of PT Employees with more than 2 Dependants 4772 Elza Magdalena 2015-09-03 FT 0 $ 94,101 Number of PT Employees hired after 2019/12/31 4296 Harshini 2014-07-15 PT 12,471 Highest salary of a PT employee 8884 Hiten 2014-09-18 FT 4 $ 67,132 Highest Witholding Tax of a FT employee 916 Hoang Anh 2016-10-11 FT 5 88,604 5803 Jawaa 2008-02-18 FT 4 $ 55,680 Range Names 8708 Kirandeep 2018-04-17 FT 1 $ 98,869 5565 Manthan Himansh 2020-04-03 PT $ 11,994 6142 Meenu 2011-01-17 PT $ 17,957 8164 Michae 2012-04-17 FT 2 66,693 4338 Nina Maripet 2019-06-26 FT 84,432 5833 Nishit 2019-08-30 PT $ 18,994 6060 Rajandeep Kaur 2020-08-13 FT 65,648 2559 Rakesh 2014-03-03 PT 18,835 24 5569 Rayshawn 2015-11-06 PT 15,525 3488 Rishpal 2020-01-08 PT 15,86: 26 7353 Sama 2020-07-14 PT $ 16 ,173 4990 Samuel 2016-11-08 PT 9,893 28 4785 Sandeep 2009-04-15 PT HAHA At 17,081 29 3040 Sandeep 2014-01-31 FT 39,364 30 8087 Seham 2007-10-18 PT 19,306 31 4474 Shanise 2018-11-07 PT 32 4251 Thanh Dat 2014-06-16 PT 33 5324 Victoria 2020-03-09 PT OUI AOAHUH 9,933 16,707 13,665 34 3123 Yogesh 2009-12-14 PT 7,688 35 $ 1,141,553 $ 36 37 38 39 40 41 42 43 Employees Loan Retirement Total Revenues Football Soccer Basketball Baseball + Select destination and press ENTER or choose Paste + 100%