Lego Vulwadon Description Multiple Attempts Not allowed. This test can only be taken once Force Completion This test can be saved and resumed later Your answers are ved automatically Question completion status 10 11 12 13 15 Moving to another question will save the response Question 8 In U17 use NESTED IF functions to enter: 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. Copy the nested functions to the rest of the cells in the column. In U14, use the appropriate function to count how many values are greater than 500. Format answer as comma style. O decimal Moving to another question will save this response H . 11 L WENYEWE CE TORTOR w WAR MINH w HA VET - W IND EN 1 WE H IN + TUR He LE ch w 61 LO HP 10 TE 2 1 11 201 UL HILDATASET Shot type here to search O 11 sl $ 130 AQUING BADPM 2025-01 RA dename Blo ZOOM 000 2000 140 2000 200 105 1207 Ver 60 L . 3751 28 21 2005 13:34 15.000 20.000 DOW 401 De 5 1 5 ANSWERS EMPLOYE 0 JOB CODE TITLE DEPARTMENT LAST NAM FIRST NAME CITY PROV POSTAL CODE RATING EDUCATIONAL LOSS MONTHLY MONTH YODOCION SAUNY 15.00 10 4 5 & VES F LIJE 1300 2 VOR IVO MIRI LH12 BUS LAN 1G4 LR16 KAW IKIA WENKE F F 3 9 593 5 2 5 TO 500 15 F AE 1651 100 1000 11100 31061 19 102 201053 21 1054 221055 2310 24 57 250 26 10 37 1060 2015061 2900 20 1053 311004 321065 33 34 1 35 1050 36 1023 3710/0 38 1 33 1972 40 1073 F 500 572001 President 601710 Accort Hep 471301 5017 AS Rep Secretary Doch 530001 Sep 1601970 Terry Serv 511111 Sor Manager 1211201 Mest Manager 51001 Service manch Manager 161203 Service Beach Manager 000 15011111 Sales Rep 510301 Service Branch Manager 8010 Service Rep 501200 Seneric 5.850 Supervis Rear 6.201 Service Bench Monat 506301 Product Manager 51710 Recourt Rep 1601510 Tech Spa 601200 Service Rep 420100 Asante Manager 610201 Service Branch Manager Installer HR DATASET Sheet1 D A . A c D D D D A A D D A c D D C A A 2 3 2 5 2 9 Since No Vors Fans scato Los Hoold Cime Mary Thom Greenwood Mega Gles P Odhe Bel Dugo Toyle Vio ER) M Ha Shala Saw Why LEV Rese Dwyer Robert Mahas Brich Ronald TE Share Manoch Saveda Vecot Aghout Hd Scatorul Zoon Sevile Malice Race Vanco Thompoon D Robbins George Odens Edward Emily Kas H Jean Paul Verde Demy Mary Scator Whale Are Missage Garder Ceg ON ON ON ON ON ON ON ON ON ON oc ON AB ON ON ON ON BO ON ON CN OC ON ON ON NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO 200 HE ILIPPI 12.152 CAN MW MOV LAX On LP KO KOA 2E 2F1 MT 3N2 BY 20 KAS 4E4 10 2015 5.2016 4BI 3 2 2 2 9 4 8 5 M F M M M F 5000 5.000 9,000 SU 9 5 2 2 9,261 1000 R 1 503 443815 BE YES 5.000 6 YES ND NO YES F M F F 4 9200 350 50510 Type here to search O BE E 199. * $ 99 $ % 9 % Insert Delete Format Analy Conditional Format Cell Formatting Tible Styles Styles Clear Sort Find & Fole Select Editing Number Cells Analys M N Rating 0 Bonus R 1 Bonus Rate 2 Bonus Rate Bonus R4 Education Ilona 1 Bonus 2 B Dep 1 10 duction Rate 4 175 215% 25540 29596 335% 045 0907 $ $ 13 200 200 OS 2 3 4 15 6 100 2001 300 4005 500 500 5 100 10003 4 5 15 1200 s OX 079% 100% 1509 200% 250% 300% 350% 450% 5.00% 035 055 02 0955 1 15% 125% 1.58% 125% 1954 215% 100% 225% 270 315% 055 100 145 1904 2-35% 280 325% 3.70% 4.15% 460% 41590 30% 8 9 30 40 4 50% LAVERAGES SUMIES COUNTIS MATCH ANSWERS 3.434 203 388 1151 370 196 198 500 CATION BILINGUAL GENDER RATING BONUS EDUCATION DEPARTMENT IF FUNCTION NESTED IF BONUS BONUS BONUS BONUS 5 4 3 2 2 YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO YES F M M F F F F M F M F M M F M M M F M M F GROSS MONTHLY NET MONTHLY DEDICTION MONTHLY SALARY SALARY 16095 $ 15.000 1,096 4190$ 4198 878115 7.500 1,231 45505 4550 4,189 $ 4189 3.5265 5,000 926 8.600 $ 7500 1100 34055 7900 905 1205/5 11000 1057 5.7713 9.000 721 98125 9.000 812 10.903 $ 9000 1933 4,7675 4767 912071 $ 9.000 207 47815 - 4781 6,145 $ 5,000 1145 65419 5000 1541 9,206 9.000 205 10,450 $9.000 1460 40965 4096 6.250 35000 1260 80473 20990 40905 250 2095 29630 43000 42025 602.85 48855 49060 54665 2003 46035 239.05 307.25 705 450 30 523.00 20480 313.00 2105 5005 40013 3005 2001$ 200 $ 90015 2005 500 5 500S 300 500S 2003 400 $ 3005 2005 200S 2005 200$ 300$ 500 $ 200 $ 2001 5.000 900 3.200700 1 500 1700 600 700 600 700 5000 700 600 700 5000 500 5.000 500 1500 500 5000 1500 600 700 3.200 700 1,500 500 600 500 600 700 600 700 600 500 1500700 5.000 504 600 700 600 700 GUZZI MIA FILE Seful ge Layout Formas w View Hels is nment Nam -AA D T 5 969 - TH han W SU Ni SE 11 ME 15 HELL 11 360 SRE w SU 12 49 SRISICO WATCH CATER AN ATVIN FURIOUS GENE TY VET MONTHLY WATER WARY SALARY WO 4 IND M BLUE 1 OH CHE 2 12 LE IE UR INC NEX ON AMELE 13 TE 12 LE 11 2 11 3 M WE HIST 50 20 ON 10 SL E 15 TE 106 TO NOZ PS 204 300 M LLO 00 TO NO NO TE LET 100 200 1 ett 141 PM 13CAD ANG @ O I . * ch BED 31 VAVENAGENS co Question IV14 AVERAGEIRS function to calculate the average Gross Morty Sawyers from water and tons of more and warga Yamu wa come the decal DOM Question 11 In cel X14 use the COUNTIES Action to determine how many yees Mantingut less than and cont 2010 Question 12 In cell Y14 use the MATCH Function to answer: What is the Row # in the range of Gross Monthly Salary data that 10656 can be found? In cell Z14 use the INDEX Function only to answer: What is the City of the employee with a Gross Monthly Salary of 106567 Question 13 In cell AA 14 use the SUBTOTAL Function only to calculate the minimum Gross Money Salary for all employees Formats com doma Fiter the data to show employees with Education of 2 or 3 from QC who are not bilingual The Subtotal value in AA 14 should update to show the result for the fired data Enter type) this new Subtotal value to AB14 (the value should remain when the titers are cleared in bolow Formatas come style doma Clear the items Lego Vulwadon Description Multiple Attempts Not allowed. This test can only be taken once Force Completion This test can be saved and resumed later Your answers are ved automatically Question completion status 10 11 12 13 15 Moving to another question will save the response Question 8 In U17 use NESTED IF functions to enter: 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. Copy the nested functions to the rest of the cells in the column. In U14, use the appropriate function to count how many values are greater than 500. Format answer as comma style. O decimal Moving to another question will save this response H . 11 L WENYEWE CE TORTOR w WAR MINH w HA VET - W IND EN 1 WE H IN + TUR He LE ch w 61 LO HP 10 TE 2 1 11 201 UL HILDATASET Shot type here to search O 11 sl $ 130 AQUING BADPM 2025-01 RA dename Blo ZOOM 000 2000 140 2000 200 105 1207 Ver 60 L . 3751 28 21 2005 13:34 15.000 20.000 DOW 401 De 5 1 5 ANSWERS EMPLOYE 0 JOB CODE TITLE DEPARTMENT LAST NAM FIRST NAME CITY PROV POSTAL CODE RATING EDUCATIONAL LOSS MONTHLY MONTH YODOCION SAUNY 15.00 10 4 5 & VES F LIJE 1300 2 VOR IVO MIRI LH12 BUS LAN 1G4 LR16 KAW IKIA WENKE F F 3 9 593 5 2 5 TO 500 15 F AE 1651 100 1000 11100 31061 19 102 201053 21 1054 221055 2310 24 57 250 26 10 37 1060 2015061 2900 20 1053 311004 321065 33 34 1 35 1050 36 1023 3710/0 38 1 33 1972 40 1073 F 500 572001 President 601710 Accort Hep 471301 5017 AS Rep Secretary Doch 530001 Sep 1601970 Terry Serv 511111 Sor Manager 1211201 Mest Manager 51001 Service manch Manager 161203 Service Beach Manager 000 15011111 Sales Rep 510301 Service Branch Manager 8010 Service Rep 501200 Seneric 5.850 Supervis Rear 6.201 Service Bench Monat 506301 Product Manager 51710 Recourt Rep 1601510 Tech Spa 601200 Service Rep 420100 Asante Manager 610201 Service Branch Manager Installer HR DATASET Sheet1 D A . A c D D D D A A D D A c D D C A A 2 3 2 5 2 9 Since No Vors Fans scato Los Hoold Cime Mary Thom Greenwood Mega Gles P Odhe Bel Dugo Toyle Vio ER) M Ha Shala Saw Why LEV Rese Dwyer Robert Mahas Brich Ronald TE Share Manoch Saveda Vecot Aghout Hd Scatorul Zoon Sevile Malice Race Vanco Thompoon D Robbins George Odens Edward Emily Kas H Jean Paul Verde Demy Mary Scator Whale Are Missage Garder Ceg ON ON ON ON ON ON ON ON ON ON oc ON AB ON ON ON ON BO ON ON CN OC ON ON ON NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO 200 HE ILIPPI 12.152 CAN MW MOV LAX On LP KO KOA 2E 2F1 MT 3N2 BY 20 KAS 4E4 10 2015 5.2016 4BI 3 2 2 2 9 4 8 5 M F M M M F 5000 5.000 9,000 SU 9 5 2 2 9,261 1000 R 1 503 443815 BE YES 5.000 6 YES ND NO YES F M F F 4 9200 350 50510 Type here to search O BE E 199. * $ 99 $ % 9 % Insert Delete Format Analy Conditional Format Cell Formatting Tible Styles Styles Clear Sort Find & Fole Select Editing Number Cells Analys M N Rating 0 Bonus R 1 Bonus Rate 2 Bonus Rate Bonus R4 Education Ilona 1 Bonus 2 B Dep 1 10 duction Rate 4 175 215% 25540 29596 335% 045 0907 $ $ 13 200 200 OS 2 3 4 15 6 100 2001 300 4005 500 500 5 100 10003 4 5 15 1200 s OX 079% 100% 1509 200% 250% 300% 350% 450% 5.00% 035 055 02 0955 1 15% 125% 1.58% 125% 1954 215% 100% 225% 270 315% 055 100 145 1904 2-35% 280 325% 3.70% 4.15% 460% 41590 30% 8 9 30 40 4 50% LAVERAGES SUMIES COUNTIS MATCH ANSWERS 3.434 203 388 1151 370 196 198 500 CATION BILINGUAL GENDER RATING BONUS EDUCATION DEPARTMENT IF FUNCTION NESTED IF BONUS BONUS BONUS BONUS 5 4 3 2 2 YES NO NO NO YES NO YES NO YES NO YES NO NO YES NO NO NO YES NO NO YES F M M F F F F M F M F M M F M M M F M M F GROSS MONTHLY NET MONTHLY DEDICTION MONTHLY SALARY SALARY 16095 $ 15.000 1,096 4190$ 4198 878115 7.500 1,231 45505 4550 4,189 $ 4189 3.5265 5,000 926 8.600 $ 7500 1100 34055 7900 905 1205/5 11000 1057 5.7713 9.000 721 98125 9.000 812 10.903 $ 9000 1933 4,7675 4767 912071 $ 9.000 207 47815 - 4781 6,145 $ 5,000 1145 65419 5000 1541 9,206 9.000 205 10,450 $9.000 1460 40965 4096 6.250 35000 1260 80473 20990 40905 250 2095 29630 43000 42025 602.85 48855 49060 54665 2003 46035 239.05 307.25 705 450 30 523.00 20480 313.00 2105 5005 40013 3005 2001$ 200 $ 90015 2005 500 5 500S 300 500S 2003 400 $ 3005 2005 200S 2005 200$ 300$ 500 $ 200 $ 2001 5.000 900 3.200700 1 500 1700 600 700 600 700 5000 700 600 700 5000 500 5.000 500 1500 500 5000 1500 600 700 3.200 700 1,500 500 600 500 600 700 600 700 600 500 1500700 5.000 504 600 700 600 700 GUZZI MIA FILE Seful ge Layout Formas w View Hels is nment Nam -AA D T 5 969 - TH han W SU Ni SE 11 ME 15 HELL 11 360 SRE w SU 12 49 SRISICO WATCH CATER AN ATVIN FURIOUS GENE TY VET MONTHLY WATER WARY SALARY WO 4 IND M BLUE 1 OH CHE 2 12 LE IE UR INC NEX ON AMELE 13 TE 12 LE 11 2 11 3 M WE HIST 50 20 ON 10 SL E 15 TE 106 TO NOZ PS 204 300 M LLO 00 TO NO NO TE LET 100 200 1 ett 141 PM 13CAD ANG @ O I . * ch BED 31 VAVENAGENS co Question IV14 AVERAGEIRS function to calculate the average Gross Morty Sawyers from water and tons of more and warga Yamu wa come the decal DOM Question 11 In cel X14 use the COUNTIES Action to determine how many yees Mantingut less than and cont 2010 Question 12 In cell Y14 use the MATCH Function to answer: What is the Row # in the range of Gross Monthly Salary data that 10656 can be found? In cell Z14 use the INDEX Function only to answer: What is the City of the employee with a Gross Monthly Salary of 106567 Question 13 In cell AA 14 use the SUBTOTAL Function only to calculate the minimum Gross Money Salary for all employees Formats com doma Fiter the data to show employees with Education of 2 or 3 from QC who are not bilingual The Subtotal value in AA 14 should update to show the result for the fired data Enter type) this new Subtotal value to AB14 (the value should remain when the titers are cleared in bolow Formatas come style doma Clear the items