AutoSave On QUIZ 2 HR DATA FILE 2021 (2) Saund- Scarch Rajesh Dip BE File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum 1 Wrap Text 2Y O X Out [B Copy Paste 3 Formattinta Cupboard de Clele on Idea 5 % *** Formatting Eestis Conditional Formatas Cell Marga Center Seng UVLY Cirar Saite Find & Filtar Select Editing Font Alignment Number Styles Cols dsas Sent wity 020 X 6 -Averageifsi020) A B C D F L M N Rating NAME Rajesh Des Chowdhury STUDENT ID 152968194 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 G G H 1 K Gross Monthly Deduction Deduction Deduction Deduction Salary Rate 1 Rate 2 Rate 3 Rate 4 $0.00 20.0% 15.05 10.0% 17.55 S 5000 250% 20.05 150% 21.5% $ 7.500 300% 25.0% 200% 25.5% $ 9.000 36.0% 30.0% 26.0% 29.5% S 11,000 3759 35.05 300% 33.55 $ 15,000 42.5% 40.0% 35.0% 37.55 S 20 000 47 54% 45.0% 400% 41.5% 1 2 2 3 4 5 5 7 8 9 10 0 P Q R Bonus Rate Bonus Rate 2 Bonus Rate 3 Bonus Rate 1 4 0.50% 0.36% 0.455 0.56% 0.75% 0 55% 0904 1.00% 100% 0.75% 1354 1.45% 1.50% 0.96% 1.909 1.90% 2.00% 1.15% 2 255 2.35% 2.50% 1.35% 2.70% 2.80% 3.00% 1.55% 3.155 3.25% 350% 1 75% 3604 3.70% 4.50% 1.95% 4055 415% 5.00% 2.15% 4.505 4.60% ANSWERS A7 130 155 500 30 JOB CODE TITLE CITY EMPLOYEE ID DEPARTMEN LAST NAME T PROV FIRST NAME POSTAL RATING EDUCATION BILINGUAL GENDER CODE D A A C ON ON ON 5 4 YES NO NO 17 1050 18 1051 19 1052 20 1063 21 1064 22 1065 23 1056 24 1067 25 1068 26 1069 622001 601710 411301 501111 304000 520201 601910 511111 411201 610201 HR DATASET President Account Rap Credit Manager Associate Sales Rep Secretary Despach Sales Rop Territory Supervisor Store Manager Marketng Manager Service Brunch Manager Sndair Farrow Jonas Clemente Gruerwood Giles IBAL Taylor Harris Whily Jennifer Devd Harold Mary Margret Paula anal Virce Shiels Ralph A C A D North York Scarborough Souville Thomhil Gormley Oshawa Cagoode RR #3 Marock Scarborough Markham ON ON ON ON ON ON ON MCR 100 MIR 2H1 L2H 1G2 L3J 1X3 L4H 164 L5R 3M5 KGA 2016 K7A 2N7 M-18W 3H8 LSP 6H9 10 4 1 1 6 9 2 7 2 2 5 2 5 5 3 NO YES NO VES NO YES NO GROSS MON AVERAGEIFSCaverage range, criteria_rangc1, critenal... MONTHLY DEDUCTION SALARY BONUS BONUS SALARY 16.095 6,438 9.657 80475 1000 4 198 630 356A 209 90 800 8.781 2 195 6586 439.05 500 4.550 683 3,869 227.50 300 4.1991 628 3,661 209 45 300 5.926 1185 4741 296 30 1030 8600 2.150 6.450 43000 300 8 405 2 101 6304 420.25 1,000 12057 4.220 7.837 602.85 1.000 9.771 2,931 5,840 498.55 500 F M M F F F F M F F M D D 2 2 Pont Type here to search 7:43 PM 1/28/2021 A Moving to another question will save this response. Question 9 of 15 uestion 9 3 points Save Answer In V14 use the AVERAGEIFS function to calculate the average Gross Monthly Salary for employees from Toronto with Rating of 5 or less and Education of 3 or less who are in Department D. Format answer as comma style, 0 decimal. AutoSave On QUIZ 2 HR DATA FILE 2021 (2) Saund- Scarch Rajesh Dip BE File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum 1 Wrap Text 2Y O X Out [B Copy Paste 3 Formattinta Cupboard de Clele on Idea 5 % *** Formatting Eestis Conditional Formatas Cell Marga Center Seng UVLY Cirar Saite Find & Filtar Select Editing Font Alignment Number Styles Cols dsas Sent wity 020 X 6 -Averageifsi020) A B C D F L M N Rating NAME Rajesh Des Chowdhury STUDENT ID 152968194 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 G G H 1 K Gross Monthly Deduction Deduction Deduction Deduction Salary Rate 1 Rate 2 Rate 3 Rate 4 $0.00 20.0% 15.05 10.0% 17.55 S 5000 250% 20.05 150% 21.5% $ 7.500 300% 25.0% 200% 25.5% $ 9.000 36.0% 30.0% 26.0% 29.5% S 11,000 3759 35.05 300% 33.55 $ 15,000 42.5% 40.0% 35.0% 37.55 S 20 000 47 54% 45.0% 400% 41.5% 1 2 2 3 4 5 5 7 8 9 10 0 P Q R Bonus Rate Bonus Rate 2 Bonus Rate 3 Bonus Rate 1 4 0.50% 0.36% 0.455 0.56% 0.75% 0 55% 0904 1.00% 100% 0.75% 1354 1.45% 1.50% 0.96% 1.909 1.90% 2.00% 1.15% 2 255 2.35% 2.50% 1.35% 2.70% 2.80% 3.00% 1.55% 3.155 3.25% 350% 1 75% 3604 3.70% 4.50% 1.95% 4055 415% 5.00% 2.15% 4.505 4.60% ANSWERS A7 130 155 500 30 JOB CODE TITLE CITY EMPLOYEE ID DEPARTMEN LAST NAME T PROV FIRST NAME POSTAL RATING EDUCATION BILINGUAL GENDER CODE D A A C ON ON ON 5 4 YES NO NO 17 1050 18 1051 19 1052 20 1063 21 1064 22 1065 23 1056 24 1067 25 1068 26 1069 622001 601710 411301 501111 304000 520201 601910 511111 411201 610201 HR DATASET President Account Rap Credit Manager Associate Sales Rep Secretary Despach Sales Rop Territory Supervisor Store Manager Marketng Manager Service Brunch Manager Sndair Farrow Jonas Clemente Gruerwood Giles IBAL Taylor Harris Whily Jennifer Devd Harold Mary Margret Paula anal Virce Shiels Ralph A C A D North York Scarborough Souville Thomhil Gormley Oshawa Cagoode RR #3 Marock Scarborough Markham ON ON ON ON ON ON ON MCR 100 MIR 2H1 L2H 1G2 L3J 1X3 L4H 164 L5R 3M5 KGA 2016 K7A 2N7 M-18W 3H8 LSP 6H9 10 4 1 1 6 9 2 7 2 2 5 2 5 5 3 NO YES NO VES NO YES NO GROSS MON AVERAGEIFSCaverage range, criteria_rangc1, critenal... MONTHLY DEDUCTION SALARY BONUS BONUS SALARY 16.095 6,438 9.657 80475 1000 4 198 630 356A 209 90 800 8.781 2 195 6586 439.05 500 4.550 683 3,869 227.50 300 4.1991 628 3,661 209 45 300 5.926 1185 4741 296 30 1030 8600 2.150 6.450 43000 300 8 405 2 101 6304 420.25 1,000 12057 4.220 7.837 602.85 1.000 9.771 2,931 5,840 498.55 500 F M M F F F F M F F M D D 2 2 Pont Type here to search 7:43 PM 1/28/2021 A Moving to another question will save this response. Question 9 of 15 uestion 9 3 points Save Answer In V14 use the AVERAGEIFS function to calculate the average Gross Monthly Salary for employees from Toronto with Rating of 5 or less and Education of 3 or less who are in Department D. Format answer as comma style, 0 decimal