In cell O17: Use the VLOOKUP function to return the Deduction Rate 2 from the appropriate table at the top of the worksheet. Multiply this Deduction Rate 2 by the Gross Monthly Salary to calculate the Monthly Deduction. Copy the function down to the other cells in the column.

In cell O14 use the appropriate function to answer: How many employees have a Monthly Deduction greater than 2500? Format answer as comma style, 0 decimal.

In cell P17: Calculate the Net Monthly Salary by subtracting the Monthly Deduction from the Gross Monthly Salary. Copy the formula to all cells in the column.

In cell P14: use the appropriate function to answer: How many employees have a Net Monthly Salary greater than 6000?

BIU A malamter Cloboard 1 Merce Centre $ % Conchital Format Mert Dele Formu Call Formatting Sy Styles Fort Soft Find & Select Eging Alignmerk Nurbor Lails des K10 X x A 3 D E F 1 M N Rating 1 NAME Rajesh das Chowdhury STUDENT ID 152968194 G H Grogs Monthly Deduction Deduction Deduction Deduction Salary Rate 1 Rate 2 Rate 3 Rate 4 $0.00 20.0% 150% 100% 176991 S 5,000 25.05 20.0% 15.05 21.5% S 7,500 300% 250% 23.09 25 55 S 9,000 350N 3008 250% 29 54 S 11,000 37.59 35.09 30.0% 23.5% S 15.000 12.50 40.0% 350% 3755 $ 20.000 17.5% 45.05 40.0 4999 1 2 3 3 2 3 4 5 6. 1 8 9 10 11 12 13 14 15 4 5 G 7 8 9 10 87 0 P Bonus Rate Bonus Rate 2 Boris Rate 1 1 050% 0.35% 0.4% 0754 0.53% 0915 100% 0.75% 1.35% 105 3.95% 1.80% 2009 L 15% 225% 2 50% 1354 2706 300% 1.569 3.15 3.50% L75% 3.80 450% 1.95% 4055 500% 2 154 4505 1 ANSWERS 871 CITY PROV TITLE DEPARTMEN LAST NAME T EMPLOYEE JOB CODE ID FIRST NAME RATING ED BONUS POSTAL RATING EDUCATION BILINGUAL GENDER CODE 16 D A 1 10 1 1 1 6 F M M F 17 1050 18 1051 19 1052 20 1053 21 1054 22 1065 23 1066 24 1057 25 1058 622001 601710 111301 1501111 304000 520201 601910 511111 1411201 1611201 President Acxxsunt Rep Credit Manager Associate Sales Rep Secretary Dispatch Sales Rep Territory Supervisor Store Manager Marketing Manager Survce Branch Manager A C A C 13 Sindst arrow Jones Clerk Greenwood Glk Bell aylor larra Whit David Harold Misry Margret Paula Janet Vide Shela Ralph North York Scarborough Shoutil Thornhil Gamley Oshawa Osade RRN3 Mancha Scarborough Markham ON MCR 10 1 ON MR 2011 ON L2H 1G2 ON L3J1X8 ON LAH 164 EN LOR3115 ON KGA21 ON K7A 2N/ ON MW 318 UN L9P5HS ! 4 3 2 2 2 5 2 5 5 5 3 YES NO NO Na YLS NO VES NO 5 NO GROSS MONTHLY NET MONTHLY MONTHLY DEDUCTION SALARY SALARY 16096 4 198 9.781 4550 4,199 5,926 8600 8.4061 12.057 3,771 2 2 7 2 2 F F M F MIL 0 3