JOB CODE TITLE CITY PROV EMPLOYEE ID DEPARTMEN LAST NAME T FIRST NAME POSTAL RATING EDUCATION BILINGUAL GENDER CODE RATING BONUS EDUCATION DEPARTMENT BONUS BONUS IF FUNCTION BONUS NESTED IF BONUS 10 4 5 4 F M M F 1050 1051 1052 1053 1054 1055 1056 1057 1058 16,095 4,198 8,781 4,550 622001 601710 |411301 501111 304000 520201 601910 1511111 |411201 President Account Rep Credit Manager Associate Sales Rep Secretary Dispatch Sales Rep Territory Supervisor Store Manager Marketing Manager D A A C A C A D D Sinclair Farrow Jones Clemente Greenwood Gilles Bell Taylor Harris Jennifer David Harold Mary Margret Paula Janet Vince Shiela North York Scarborough Stouffville Thornhill Gormley Oshawa Osgoode RR #3 Manotick Scarborough ON ON ON ON ON ON ON ON ON MOR 1VO M1R 2H1 L2H 1G2 L3J 1X3 L4H 164 L5R 3M5 KOA 2W6 K7A 2N7 M8W 3H8 1 1 6 GROSS MONTHLY NET MONTHLY MONTHLY DEDUCTION SALARY SALARY 5,633 10,462 420 3,778 1,756 7,025 455) 4,095 4,189 419 3,7701 5,926 889 5,037 8,600 1,720) 6,880 8,405 1,681 6,724 12,057 3,617 8,440 YES NO NO NO YES NO YES NO YES 3 2 2 5 2 5 1,200 750 600 400 400 F 378.23 79.76 127.32 45.50 41.89 139.26 86.00 197.52 283.34 900 400 400 700 400 700 400 900 900 700 250 250 250 250 700 250 700 700 9 F 1,200 2 7 F M F 400 1,200 1,200 2 5 In U17 use NESTED IF functions to enter: the value 500, if the CITY is Mississauga, the value 350, if the CITY is Winnipeg, the value 485, if the CITY is Richmond Hill, the value 450, if the CITY is Ottawa, otherwise the value 315. Copy the nested functions to the rest of the cells in the column. In U14, use the appropriate function to calculate the total for all employees. Format answer as comma style, 0 decimal