everything is clear and complete information provided

29 MUR BE 15 PUBEE MC Monty duty ADING O Po hop 11 PLOTEE OBCODE TIE DEPARTMENT LAST NAME CITY FIRST NAME PROV RATING EDUCATION BILINGUAL POSTAL CODE D A A C Jenter David Fan VOR IVO MIR 241 L2H 162 50 Cape See SOD Ses Som Mery Marget North York Scatore Scule Thothil Com Out Osgood RREO Marcok Cente Gewood Get Bel Toyo H Whe Peis 10 4 1 1 6 9 2 7 2 2 T4H 164 LR 35 KBA2W KIAN VW LASH Scharger Vince She Rach More Ra RO hl MA Das P Vid 5 4 3 2 2 5 2 5 5 3 5 2 4 3 2 2 2 2 Sot Dw W Band Manager ON ON ON ON ON ON ON ON ON ON 00 ON AB ON ON ON ON ON ON ON ON ON ON ON A D D 0 0 A A D D A C D A 0 c A A A c 1 Beve VUI Maced Ancol Sektor Scute Vanco Ah 9 8 9 4 YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO YES YES NO NO YES NA som Man Acer LPP 122 12 KAN Mt24 175 TAD VP PAR KC 29 MAZED HH2P VEN 1200 Then R TO He 5 5 7 9 8 6 El Kar DP Mary ME NO Day Beatro 5 2 2 2 3 HR DATASET Cras f M F 4 F M Type here to search O 99. scale 100 ondine Print Print Sheet Options Scato a Arrange 2 M G Goethe Salary H Bedste Rate Delen K De RA one! B 15 LS IS OS 3 50 N 0 Rating Set 02 16 OM 10 DS 133 120 19 DA TON 1199 2 2 MO ge UST 2011 wa LAT DAS D 1 MES * 1 1 TO 150 LEO 59 G 1 11 2 WO 950 WA 30 1 TO WE 3 SR ZER WOW ANSAS 344 715 115 1 STA 251 CITY PRON ONIH UCATIONAL GENDER POSTAL CODE EATON DEWENI INCH RO WAL SINOS GROSS MONTHLY NET MONTHLY DEDUCTION MONTNEY IALAR BALAY Tr ha D 1 1 4 NO 705 TO ON SIA DLL FIT u 1 TE 13 RE w 13 YER SEX ON 3 3 O GE ILM WAN TRIAN WW YE LOT ON ON SELE 300d 100 ( D OR ON 39 + 2003 15 TE W TH SUNT MA LDL UL 10 Oh YE 1 20 1 IN ON ww NO 10 YE M LOS 500 W 4 NO WO M on M 10 10 TE Twy ON 0 90 . GE 114 30C Mostly doudy ADONG O EL E ViewHelp Share Comments Genie ei SIG Sand Toll Sindion Align Group Rocate Pri SF Sher Option BY ET UY to Bot Buna Dr Vals 90 DEN 1999 11 1 WORD 2015 On 10 200 13 00 1 2 30 15 B 10 C. 11 11 w 30 Map BE 29 08 50 10 WOT STU M ON 30 De AVERAGERS SAS CORTES MATCH NE RA TOTAL FILTER ICON BATH BONUS UCATION DEPARTMENT FUNCTION NEED BONUS BONUS TIN MONTH ULAY ST TE DS ST TE DT PE 11 MO 7 MER 6 IN O 10 5000 TE USE HO TO . LION EXE TE BE DIE TO X RE BY 11 27 1 20 LI 1) Sa REL HERE 30 Tel TH 10 ED FI * 30C Mostly cloudy AD ENG 3:40 PM 2021-09-29 Question 8 of 15 Question 8 3 points Save Answer In U17 use NESTED IF functions to enter: A A D D D D . the value in AG2. If the PROVINCE IS ON the value in AG3, if the PROVINCE IS BC the value in AG4, if the PROVINCE IS AB the value in AG5, if the PROVINCE IS MB, otherwise the value in AG6. . A Copy the nested functions to the rest of the cells in the column. D A C D A D in U14, use the appropriate function to count how many values are greater than 500. Format answer as comma style, 0 decimal A JOB CODE TITLE DEPARTMENT LAST NAME CITY PROV RATING EDUCATION BILINGUA PLOYEE ID FIRST NAME POSTAL CODE ON ON ON ON ON ON ON ON ON 10 4 1 1 6 9 2 7 2 2 5 ON D A A D D D D A A D D 0 D C A A C 50 622001 President 151 601710 Account Rep 052 411301 Credit Manager 053 1501111 Associate Sales Rep 8054 304000 Secretary Dispatch 1065 520201 Sales Rep 096 601910 Temory Supervisor 1057 1511119 Store Manager 1036 411201 Marketing Manager 1059 1510201 Service Branch Manager 1050 610201 Service Branch Manager 1061 10310 Product Manager S 1062 1501111 Sales Rep 16.10301 Service Branch Manager 201210 Service Rep 32 13 1504200 Senior Instructor 331066 509501 Supervisor Repair 340 010201 Service Branch Manager 356 15301 Product Manage 35 60110 Account Rep 27 1070 601510 Tech Spec 33 071 01210 Senace to 3911072 T100 Antistant Credit Manager 2003 1201 Service Branch Manager 11 Iruder IND HR DATASET Sinclair Farrow Jones Clemente Groenwood Glles Bell Taylor Hamo Whty Levesque Dwyer Brach Easton Saveda Hal Zotan Mace Thompson Robbins Edwarda Hole Derry Jennifer David Harold Mary Margret Paula Janet Vince Shiela Ralch Monique Robert Ronald Shree Vincent Albet John Rachel Chades George Emily Jean Paul Mary Anel Crag Ivan North York Scarborough Stoutile Thomh Gomley Oshowa Osgoode RR Marotick Scarborough Markham Rivier Des Fra Martha Calgary Mirock Agincourt Scarborough Souville Vancouver Micha Odans Kars Vertu Scarborough Mississa Nepen A 5 4 3 2 2 5 2 5 5 3 5 2 4 MOR IVO MIR 2H1 L2H102 130 1X3 LAH 104 LR VS K6A 2W5 KIA 2N7 w LSP 5H9 HEZO LIP51 T2L1E2 KA 2N3 MW21 MSV 215 LGA 775 VP3 LEPARS KSC 29 KOA 20 HIH2P1 MZT 3N2 LY 203 KA6484 QC ON AB ON ON ON ON BC ON ON ON QC ON ON ON ON YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO YES YES NO NO YES 09052 51054 8 9 4 8 5 7 9 8 G 8 4 1 2 2 2 2 3 5 2 2 2 3 2 W Gardner Type here to search O RE 99 6 10 450% 5009 195% 2.15% 4.05 4.50% 3.70% 415% 460% ANSWERS 3434303 ELE 115 370 158 RATING IST GARDS AVERAGEWS 5702 AL DE COF EDUCATION BILINGUAL GENDER NET RATING BONUS EDUCATION DEPARTMENT OF FUNCTION NESTED BONUS BONUS BONUS BONUS 10 4 1 1 9 YES NO NO NO YES NO YES NO YES NO YES 925 5 4 3 2 2 5 2 5 5 3 5 2 4 VO H1 32 23 164 3M5 216 2N7 N3HB 510 E470 P5P1 1162 3A 2N3 W 2M 15V 2.35 BATX VIP 27 LP ARE K9C 2K9 HIH 2P1 MTN2 L 233 K45 44 9 2 7 2 2 5 2 9 8 9 4 5 3336563 F M M F F F F M F M F M M F GROSS MONTHLY MONTHLY DEDUCTION MONTHLY SALARY SALARY 160966 15000 1,055 4.1985 4,198 87515 7,500 1281 45505 4550 41895 4189 5.926 $ 5000 8.500 5 700 1100 3455 17.500 900 12,0576 11.000 102 9.7715 9.000 771 98125 91000 812 109335 9.000 1,933 476715 4759 9.2015 201 4/15 4761 61495 5000 To 6540S 1541 9200 $ 20 104505 1.6.0 4065 2016 10 6/01 4419 LO 50 10 10 9000 2010 ME Run + 204.75 20990 439.08 2750 209.45 29830 400.00 4205 6200 48055 49050 51668 2015 48035 2356 ON 5003 5000 750 00S 3200 300 1500 2015 600700 2009 700 5008 5000 2015 6007/08 500S 5000 500 5000 5000 500 2015 500 500 SUS 5.60 500 2005 Thou 4308 3220 205 T500 2001 SO 2005 10000 2015 700 2013 10 36 CORO 2013 FO 2000 EVO 2013 20 NO YES 0006 ON ON ON 0035 0006 200 YES 5. 250.30 333000 20 ON 2 2 2 2 3 5 2 2 2 3 500S BOX M w F M M F M 1 F M WIE STICE 9 3 5 3 2 1 57607 NO YES YES NO NO YES TE WWE 59 30C Mostly doudy DOING 99+ hp Titles Scale 100% La Print Print Send Forward Backward Selection Align Group Rota Pane Scale to Fit Sheet Options Arrange M N Rating 0 P R Bonus Rate 1 Bonus Rate 2 Bonus Rate 3 Bonus Rate 4 G J Gross Monthly Deduction Deduction Deduction Deduction Salary Rate 1 Rate 2 Rate 3 Rate 4 $0.00 200% 15.0% 100% 175% $ 5,000 25.0% 20.0% 150% 215% $ 7,500 30.095 25.0% 20 0% 25 5% $ 9000 350% 30.0% 25.0% 29596 $ 11,000 37.5% 35.0% 30.0% 33.5% 15.000 42.5% 40.0% 35096 37596 IS 20000 47596 45096 400% 415% nene 1 2 3 4 5 6 7 8 9 10 0.50% 0759 100% 1.50% 200% 25096 3.0096 35096 4.50% 5.0096 03596 0.55% 0.75% 0.95% 1.1596 13596 1.5596 175% 19596 2 15% 0459 0.90% 1 35% 1809 2 25% 270% 3.1596 3.6096 40546 450% 05596 10096 145% 190% 2.35% 2 80% 3.25% 3.70% 415% 46096 ANSWERS 3,434 3001 333 115) 370 198 ERST AME CITY PROV POSTAL CODE RATING EDUCATION BILINGUAL GENDER RATING BONUS EDUCATION DEPARTM BONUS BONUS id old 80475 209 90 23965 22750 209.05 2360 net ce mela ch longue North York Scarborouch Stavite Thomh Gormley Oshaw Dupade RR Mancock Scatorough Mih Riviere Des Pra Martha Cor Marck Ancourt Scarborough Sode ON ON ON ON ON ON ON ON ON ON QC ON AB ON ON ON ON MOR 1VO MIR 2H1 L24162 EUX LAH 14 L5RMS IKA 216 KIA 2N7 MOW 3HB 19P 5H9 HOE AD 1P 5P1 12. 152 KA 2N3 MW 2 MSV 205 L6A 726 10 4 1 1 6 9 2 7 2 2 5 2 9 8 9 4 SO 60 500 5 4 3 2 2 5 2 5 5 3 5 2 4 YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO GROSS MONTHLY NET MONTHLY DEDUCTION MONTHLY SALARY SALARY 16.095 15.000 1.055 4,198 $ 4,198 8,781 $ 7,500 1.281 4550 4550 4.189 $ 4189 5,9265 5.000 926 8600 $ 7500 1.100 8,405 7,500 905 120575 11,000 1.657 9.7715 9,100 9 $123 9.000 812 10,9805 9000 1930 473 4767 9.2075 9.000 20 4751 6 1455 5.000 1155 65403 5000 101 F M M E F F F M F M F M M F M M M 500 5 400 15 3003 2003 2005 5005 2003 5005 3205 20015 9005 2003 2015 2003 2003 420 25 R285 2355 4900 56.65 2285 4505 219 05 Ronald Share View Aher Tusen 500 5000 20 3.2003 1900 SL 2 2 2 W 2008 En ITOOL Parc up Scale to Fit Sheet Options is Arrange s N Rating 0 P R Bonus Rate 1 Bonus Rate 2 Bonus Rate 3 Bonus Rate 4 U Education V Bonus 1 W Bonus 2 X Bonus ) 1 2 3 4 5 1 2 3 4 5 6 7 8 9 10 $ $ $ 5 $ 200 400 600 750 1.200 0.45% 0.90% 1.35% 1809 225% 2.70% 3.15% 3.60% 405% 4.5096 150 $ 3003 500 $ 800S 1,000 $ 0.50% 0.75% 100% 150% 200% 250% 3.00% 3.50% 4 50% 5.00% 0.55% 100% 145% 1 90% 2 35% 2.80% 3.25% 3.70% 4.15% 4.60% 1005 200 $ 300 $ 400S 500S 0.35% 0.55% 0.75% 0.95% 1.15% 1.35% 1.5596 1.75% 195% 2.15% AVERAGEIFS 5762 SWERS 3.434 333 333 3701 COUNTIFS 10 115 198 SUMIFS 2.842751 MATCH 10,65 198 500 ENDER F M M F F F F M F M E M M F M M M GROSS MONTHLY NET RATING EDUCATION DEPARTMENT OF FUNCTION NESTED IF MONTHLY DEDUCTION MONTHLY BONUS BONUS BONUS BONUS BONUS SALARY SALARY 16,095$ 15,000 1095 304 75 500$ 5000 1500 4 1985 4198 209 90 400 $ 3200 700 87815 7500 1281 439 05 3005 1.500 1700 45505 4550 22750 200 $ 690 700 4.1895 4.189 209.45 2005 600 700 59765 5,000 925 296.30 500S 5000 700 8.600$ 7,500 1,100 43000 2005 600 700 84055 7500 905 420.25 500S 5,000 500 12.0575 11 000 1,057 600 85 500S 5000 500 97115 9000 771 48855 300$ 1.500 1500 9,8125 9,000 812 490 60 500 $ 5,000 500 10,93 $ 9.000 1.933 5465 2005 600 700 4757 $ 4,767 238 35 400 $ 3.200 700 9.2015 9.000 207 46035 3005 1,500 500 4781 S 4.781 23905 2003 60500 6 145$ 5,000 1,145 30725 2005 60 700 55111 5.000 1541 32705 2005 600 700 921 50 205 4603 2005 600 500 3 Share Comment -adings View Print E Di Bring Send Forward Backward Selection Align Group Rotate Pane Arrange ons AB AC AD w Bonus 2 Borut Education Bonus 1 Bonus 3 Department Bonus 2 Bonus AE V V2 2 LE 200 00015 OS 200 400 S $ $ $ $ 150 15 3005 500S 800S 1.000 O C D 100 $ 2005 3005 400 500S 15 15 S $ 030 500 100 900 RE 7513 6365 2 3 4 5 10002 1 2005 750 1200 SUBTOTAL FETER SUMIES 2842.751 AVERAGEIFS 5,762 MATCH INDEX 10 686 Toro COUNTIFS 10 500 TION NESTED IF US BONUS 29 MUR BE 15 PUBEE MC Monty duty ADING O Po hop 11 PLOTEE OBCODE TIE DEPARTMENT LAST NAME CITY FIRST NAME PROV RATING EDUCATION BILINGUAL POSTAL CODE D A A C Jenter David Fan VOR IVO MIR 241 L2H 162 50 Cape See SOD Ses Som Mery Marget North York Scatore Scule Thothil Com Out Osgood RREO Marcok Cente Gewood Get Bel Toyo H Whe Peis 10 4 1 1 6 9 2 7 2 2 T4H 164 LR 35 KBA2W KIAN VW LASH Scharger Vince She Rach More Ra RO hl MA Das P Vid 5 4 3 2 2 5 2 5 5 3 5 2 4 3 2 2 2 2 Sot Dw W Band Manager ON ON ON ON ON ON ON ON ON ON 00 ON AB ON ON ON ON ON ON ON ON ON ON ON A D D 0 0 A A D D A C D A 0 c A A A c 1 Beve VUI Maced Ancol Sektor Scute Vanco Ah 9 8 9 4 YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO YES YES NO NO YES NA som Man Acer LPP 122 12 KAN Mt24 175 TAD VP PAR KC 29 MAZED HH2P VEN 1200 Then R TO He 5 5 7 9 8 6 El Kar DP Mary ME NO Day Beatro 5 2 2 2 3 HR DATASET Cras f M F 4 F M Type here to search O 99. scale 100 ondine Print Print Sheet Options Scato a Arrange 2 M G Goethe Salary H Bedste Rate Delen K De RA one! B 15 LS IS OS 3 50 N 0 Rating Set 02 16 OM 10 DS 133 120 19 DA TON 1199 2 2 MO ge UST 2011 wa LAT DAS D 1 MES * 1 1 TO 150 LEO 59 G 1 11 2 WO 950 WA 30 1 TO WE 3 SR ZER WOW ANSAS 344 715 115 1 STA 251 CITY PRON ONIH UCATIONAL GENDER POSTAL CODE EATON DEWENI INCH RO WAL SINOS GROSS MONTHLY NET MONTHLY DEDUCTION MONTNEY IALAR BALAY Tr ha D 1 1 4 NO 705 TO ON SIA DLL FIT u 1 TE 13 RE w 13 YER SEX ON 3 3 O GE ILM WAN TRIAN WW YE LOT ON ON SELE 300d 100 ( D OR ON 39 + 2003 15 TE W TH SUNT MA LDL UL 10 Oh YE 1 20 1 IN ON ww NO 10 YE M LOS 500 W 4 NO WO M on M 10 10 TE Twy ON 0 90 . GE 114 30C Mostly doudy ADONG O EL E ViewHelp Share Comments Genie ei SIG Sand Toll Sindion Align Group Rocate Pri SF Sher Option BY ET UY to Bot Buna Dr Vals 90 DEN 1999 11 1 WORD 2015 On 10 200 13 00 1 2 30 15 B 10 C. 11 11 w 30 Map BE 29 08 50 10 WOT STU M ON 30 De AVERAGERS SAS CORTES MATCH NE RA TOTAL FILTER ICON BATH BONUS UCATION DEPARTMENT FUNCTION NEED BONUS BONUS TIN MONTH ULAY ST TE DS ST TE DT PE 11 MO 7 MER 6 IN O 10 5000 TE USE HO TO . LION EXE TE BE DIE TO X RE BY 11 27 1 20 LI 1) Sa REL HERE 30 Tel TH 10 ED FI * 30C Mostly cloudy AD ENG 3:40 PM 2021-09-29 Question 8 of 15 Question 8 3 points Save Answer In U17 use NESTED IF functions to enter: A A D D D D . the value in AG2. If the PROVINCE IS ON the value in AG3, if the PROVINCE IS BC the value in AG4, if the PROVINCE IS AB the value in AG5, if the PROVINCE IS MB, otherwise the value in AG6. . A Copy the nested functions to the rest of the cells in the column. D A C D A D in U14, use the appropriate function to count how many values are greater than 500. Format answer as comma style, 0 decimal A JOB CODE TITLE DEPARTMENT LAST NAME CITY PROV RATING EDUCATION BILINGUA PLOYEE ID FIRST NAME POSTAL CODE ON ON ON ON ON ON ON ON ON 10 4 1 1 6 9 2 7 2 2 5 ON D A A D D D D A A D D 0 D C A A C 50 622001 President 151 601710 Account Rep 052 411301 Credit Manager 053 1501111 Associate Sales Rep 8054 304000 Secretary Dispatch 1065 520201 Sales Rep 096 601910 Temory Supervisor 1057 1511119 Store Manager 1036 411201 Marketing Manager 1059 1510201 Service Branch Manager 1050 610201 Service Branch Manager 1061 10310 Product Manager S 1062 1501111 Sales Rep 16.10301 Service Branch Manager 201210 Service Rep 32 13 1504200 Senior Instructor 331066 509501 Supervisor Repair 340 010201 Service Branch Manager 356 15301 Product Manage 35 60110 Account Rep 27 1070 601510 Tech Spec 33 071 01210 Senace to 3911072 T100 Antistant Credit Manager 2003 1201 Service Branch Manager 11 Iruder IND HR DATASET Sinclair Farrow Jones Clemente Groenwood Glles Bell Taylor Hamo Whty Levesque Dwyer Brach Easton Saveda Hal Zotan Mace Thompson Robbins Edwarda Hole Derry Jennifer David Harold Mary Margret Paula Janet Vince Shiela Ralch Monique Robert Ronald Shree Vincent Albet John Rachel Chades George Emily Jean Paul Mary Anel Crag Ivan North York Scarborough Stoutile Thomh Gomley Oshowa Osgoode RR Marotick Scarborough Markham Rivier Des Fra Martha Calgary Mirock Agincourt Scarborough Souville Vancouver Micha Odans Kars Vertu Scarborough Mississa Nepen A 5 4 3 2 2 5 2 5 5 3 5 2 4 MOR IVO MIR 2H1 L2H102 130 1X3 LAH 104 LR VS K6A 2W5 KIA 2N7 w LSP 5H9 HEZO LIP51 T2L1E2 KA 2N3 MW21 MSV 215 LGA 775 VP3 LEPARS KSC 29 KOA 20 HIH2P1 MZT 3N2 LY 203 KA6484 QC ON AB ON ON ON ON BC ON ON ON QC ON ON ON ON YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO YES YES NO NO YES 09052 51054 8 9 4 8 5 7 9 8 G 8 4 1 2 2 2 2 3 5 2 2 2 3 2 W Gardner Type here to search O RE 99 6 10 450% 5009 195% 2.15% 4.05 4.50% 3.70% 415% 460% ANSWERS 3434303 ELE 115 370 158 RATING IST GARDS AVERAGEWS 5702 AL DE COF EDUCATION BILINGUAL GENDER NET RATING BONUS EDUCATION DEPARTMENT OF FUNCTION NESTED BONUS BONUS BONUS BONUS 10 4 1 1 9 YES NO NO NO YES NO YES NO YES NO YES 925 5 4 3 2 2 5 2 5 5 3 5 2 4 VO H1 32 23 164 3M5 216 2N7 N3HB 510 E470 P5P1 1162 3A 2N3 W 2M 15V 2.35 BATX VIP 27 LP ARE K9C 2K9 HIH 2P1 MTN2 L 233 K45 44 9 2 7 2 2 5 2 9 8 9 4 5 3336563 F M M F F F F M F M F M M F GROSS MONTHLY MONTHLY DEDUCTION MONTHLY SALARY SALARY 160966 15000 1,055 4.1985 4,198 87515 7,500 1281 45505 4550 41895 4189 5.926 $ 5000 8.500 5 700 1100 3455 17.500 900 12,0576 11.000 102 9.7715 9.000 771 98125 91000 812 109335 9.000 1,933 476715 4759 9.2015 201 4/15 4761 61495 5000 To 6540S 1541 9200 $ 20 104505 1.6.0 4065 2016 10 6/01 4419 LO 50 10 10 9000 2010 ME Run + 204.75 20990 439.08 2750 209.45 29830 400.00 4205 6200 48055 49050 51668 2015 48035 2356 ON 5003 5000 750 00S 3200 300 1500 2015 600700 2009 700 5008 5000 2015 6007/08 500S 5000 500 5000 5000 500 2015 500 500 SUS 5.60 500 2005 Thou 4308 3220 205 T500 2001 SO 2005 10000 2015 700 2013 10 36 CORO 2013 FO 2000 EVO 2013 20 NO YES 0006 ON ON ON 0035 0006 200 YES 5. 250.30 333000 20 ON 2 2 2 2 3 5 2 2 2 3 500S BOX M w F M M F M 1 F M WIE STICE 9 3 5 3 2 1 57607 NO YES YES NO NO YES TE WWE 59 30C Mostly doudy DOING 99+ hp Titles Scale 100% La Print Print Send Forward Backward Selection Align Group Rota Pane Scale to Fit Sheet Options Arrange M N Rating 0 P R Bonus Rate 1 Bonus Rate 2 Bonus Rate 3 Bonus Rate 4 G J Gross Monthly Deduction Deduction Deduction Deduction Salary Rate 1 Rate 2 Rate 3 Rate 4 $0.00 200% 15.0% 100% 175% $ 5,000 25.0% 20.0% 150% 215% $ 7,500 30.095 25.0% 20 0% 25 5% $ 9000 350% 30.0% 25.0% 29596 $ 11,000 37.5% 35.0% 30.0% 33.5% 15.000 42.5% 40.0% 35096 37596 IS 20000 47596 45096 400% 415% nene 1 2 3 4 5 6 7 8 9 10 0.50% 0759 100% 1.50% 200% 25096 3.0096 35096 4.50% 5.0096 03596 0.55% 0.75% 0.95% 1.1596 13596 1.5596 175% 19596 2 15% 0459 0.90% 1 35% 1809 2 25% 270% 3.1596 3.6096 40546 450% 05596 10096 145% 190% 2.35% 2 80% 3.25% 3.70% 415% 46096 ANSWERS 3,434 3001 333 115) 370 198 ERST AME CITY PROV POSTAL CODE RATING EDUCATION BILINGUAL GENDER RATING BONUS EDUCATION DEPARTM BONUS BONUS id old 80475 209 90 23965 22750 209.05 2360 net ce mela ch longue North York Scarborouch Stavite Thomh Gormley Oshaw Dupade RR Mancock Scatorough Mih Riviere Des Pra Martha Cor Marck Ancourt Scarborough Sode ON ON ON ON ON ON ON ON ON ON QC ON AB ON ON ON ON MOR 1VO MIR 2H1 L24162 EUX LAH 14 L5RMS IKA 216 KIA 2N7 MOW 3HB 19P 5H9 HOE AD 1P 5P1 12. 152 KA 2N3 MW 2 MSV 205 L6A 726 10 4 1 1 6 9 2 7 2 2 5 2 9 8 9 4 SO 60 500 5 4 3 2 2 5 2 5 5 3 5 2 4 YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO GROSS MONTHLY NET MONTHLY DEDUCTION MONTHLY SALARY SALARY 16.095 15.000 1.055 4,198 $ 4,198 8,781 $ 7,500 1.281 4550 4550 4.189 $ 4189 5,9265 5.000 926 8600 $ 7500 1.100 8,405 7,500 905 120575 11,000 1.657 9.7715 9,100 9 $123 9.000 812 10,9805 9000 1930 473 4767 9.2075 9.000 20 4751 6 1455 5.000 1155 65403 5000 101 F M M E F F F M F M F M M F M M M 500 5 400 15 3003 2003 2005 5005 2003 5005 3205 20015 9005 2003 2015 2003 2003 420 25 R285 2355 4900 56.65 2285 4505 219 05 Ronald Share View Aher Tusen 500 5000 20 3.2003 1900 SL 2 2 2 W 2008 En ITOOL Parc up Scale to Fit Sheet Options is Arrange s N Rating 0 P R Bonus Rate 1 Bonus Rate 2 Bonus Rate 3 Bonus Rate 4 U Education V Bonus 1 W Bonus 2 X Bonus ) 1 2 3 4 5 1 2 3 4 5 6 7 8 9 10 $ $ $ 5 $ 200 400 600 750 1.200 0.45% 0.90% 1.35% 1809 225% 2.70% 3.15% 3.60% 405% 4.5096 150 $ 3003 500 $ 800S 1,000 $ 0.50% 0.75% 100% 150% 200% 250% 3.00% 3.50% 4 50% 5.00% 0.55% 100% 145% 1 90% 2 35% 2.80% 3.25% 3.70% 4.15% 4.60% 1005 200 $ 300 $ 400S 500S 0.35% 0.55% 0.75% 0.95% 1.15% 1.35% 1.5596 1.75% 195% 2.15% AVERAGEIFS 5762 SWERS 3.434 333 333 3701 COUNTIFS 10 115 198 SUMIFS 2.842751 MATCH 10,65 198 500 ENDER F M M F F F F M F M E M M F M M M GROSS MONTHLY NET RATING EDUCATION DEPARTMENT OF FUNCTION NESTED IF MONTHLY DEDUCTION MONTHLY BONUS BONUS BONUS BONUS BONUS SALARY SALARY 16,095$ 15,000 1095 304 75 500$ 5000 1500 4 1985 4198 209 90 400 $ 3200 700 87815 7500 1281 439 05 3005 1.500 1700 45505 4550 22750 200 $ 690 700 4.1895 4.189 209.45 2005 600 700 59765 5,000 925 296.30 500S 5000 700 8.600$ 7,500 1,100 43000 2005 600 700 84055 7500 905 420.25 500S 5,000 500 12.0575 11 000 1,057 600 85 500S 5000 500 97115 9000 771 48855 300$ 1.500 1500 9,8125 9,000 812 490 60 500 $ 5,000 500 10,93 $ 9.000 1.933 5465 2005 600 700 4757 $ 4,767 238 35 400 $ 3.200 700 9.2015 9.000 207 46035 3005 1,500 500 4781 S 4.781 23905 2003 60500 6 145$ 5,000 1,145 30725 2005 60 700 55111 5.000 1541 32705 2005 600 700 921 50 205 4603 2005 600 500 3 Share Comment -adings View Print E Di Bring Send Forward Backward Selection Align Group Rotate Pane Arrange ons AB AC AD w Bonus 2 Borut Education Bonus 1 Bonus 3 Department Bonus 2 Bonus AE V V2 2 LE 200 00015 OS 200 400 S $ $ $ $ 150 15 3005 500S 800S 1.000 O C D 100 $ 2005 3005 400 500S 15 15 S $ 030 500 100 900 RE 7513 6365 2 3 4 5 10002 1 2005 750 1200 SUBTOTAL FETER SUMIES 2842.751 AVERAGEIFS 5,762 MATCH INDEX 10 686 Toro COUNTIFS 10 500 TION NESTED IF US BONUS