Needing help with questions 1 4 Please Department Bonus If the Dept is 6007, enter 900, if it is 4305, enter 600, if it is 4312, enter 350, otherwise enter 200 Copy the function down for the employees Calculate the total Department Bonus in cell Q1 OR IF AND etc ent Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus AND IF value for each employee based on R etc the Days Absent Calculate the total bonus for all the employees in R1 Comment Use VLOOKUP to insert the appropriate comment for each employee How many employees have the Good comment IF AND OR etc If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0 What is the total Calculate the total in T1 If the Units Made is 17000 or more IF AND OR the Units Rejected is 2000 or OR etc less AND the Rating is A or B enter 1000, otherwise enter 0 What is the total Calculate the total in U1 ID Cc If the 3rd character of the ID IF AND I is a 3,5 or 8 AND the Rating OR etc is A, B, C or D enter 750, otherwise enter 0 Calculate the total in V1 ID Cc If the 3rd character of the ID IF AND I is a 3,5 or 8 AND the Rating OR etc is A, B, C or D enter 750, otherwise enter 0 Calculate the total in V1 If the ID ends with a 2, 4, 6, DIF AND ORTlor 8 and the Days Absent is cc etc 2 or less, enter 500, otherwise the cell should be blank What is the total Calculate the total in W1 RIF AND OR etc If the Department begins with 43 or 60 and the Units Made 19000 or more, enter Yes, otherwise enter No How many Yes are there C D E F G H 1 J K L M N o Q R T U V W Z Age Gender Salary Comment IF AND IF AND First Name Date of Hire Date of Birth Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Department Bonus Days Absent Bonus IF AND OR etc IF AND OR IF AND OR etc etc OR etc OR etc B A B 1 Employee Data 2 3 Employee Last Name ID 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Alboucq 12 11631 Alexander 13 14548 Alvardo $ $ 1 4 B C $ 1 E Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion 24 Jun 85 16 Oct 58 25 Mar 85 28 Jan 55 26 Apr 895 Oct 50 1 Feb 91 21 Dec 64 29 May 79 8 Apr 58 15 Oct 89 22 Apr 70 12 Jan 92 28 May 64 6 Jul 0016 Oct 62 21 Feb 05 26 Mar 76 61 49 F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F $ $ 91,000 50,000 31,000 48,000 47,000 90,000 100,000 29,000 53,000 D 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 01 30 16,309 30 19,089 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 $ D 3 41 $ E A 4 $ $ A 4 X E P Q U Y Z AA BUS308 Quiz1 (1) A B Employee Last Name ID First Name D Date of Hire F Age H Salary Gender Date of Birth M N Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Comment Department Bonus R Days Absent Bonus T IF AND OR etc IF AND OR etc V IF AND OR etc W IF AND OR IF AND OR etc etc B 1 4 B C 1 E D 0 D 3 4 E A 4 4 4 0 A E E A 2 4 4 D C 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 0 28 8 14 7 33 1 32 8 46 6 15 8 16 31 25 01 43 6 27 6 25 9 36 6 22 1 27 4 21 2 23 7 32 91 3 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Albouca 12 11631 Alexander 13 14548 Alvardo 14 14957 Anderson 15 12911 Anderson 16 14048 Ansari 17 13827 Atkinson 18 14765 Bacon Jr 19 13250 Baldwin 20 14923 Balke 21 14675 Barbariol 22 10827 Barnhill 23 14584 Barr 24 10149 Barrett 25 11889 Bartkowski 26 14347 Beck 27 12005 Ben Sachar 28 10069 Benson 29 12061 Berge 30 12833 Berglund 31 12037 Bergman 32 10940 Berry 33 13232 Blakeman 34 14038 Blose 35 11061 Bockman 36 13700 Bogdan HAN Employee Data 2 Anas 24 Jun 85 16 Oct 58 Kim 25 Mar 85 28 Jan 55 Pilar 26 Apr 89 5 Oct 50 Jeff 1 Feb 91 21 Dec 64 Kim 29 May 79 8 Apr 58 Sarah 15 Oct 89 22 Apr 70 Steve 12 Jan 92 28 May 64 Sean 6 Jul 00 16 Oct 62 Marion 21 Feb 05 26 Mar 76 Amy 11 Apr 92 1 Nov 70 Charlie 6 Jun 06 20 Jun 76 Zachary 27 Dec 87 26 Sep 51 Teresa 6 Apr 88 14 Jan 61 Dan 22 Jun 74 15 May 49 Amie 21 Apr 05 24 Nov 77 Wendy 21 Oct 04 15 Dec 76 Angela 16 Feb 96 18 Apr 64 Josh 26 Jul 77 12 Oct 54 Adam 9 Jul 93 8 Apr 59 Holly 14 Mar 95) 30 Jan 70 Joanna 13 Jul 84 28 Feb 54 Bradley 20 Dec 98 5 Feb 58 Ido 21 Sep 93 12 Jul 56 Max 22 Nov 99 2 Sep 75 Karen 1 Jun 97 27 Feb 65 Andreas 19 Mar 88 21 Oct 54 Ken 17 Mar 01 28 Jan 74 Jo 20 Sep 00 14 Jun 66 Synthia 1 Feb 91 21 Dec 64 Cleotilde 11 Sep 8727 May 56 Anne 20 Aug 98 18 Nov 51 Deadra 27 Mar 91 20 Jul 64 61 49F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F 49 44 F 43 80 M 68 55 M 59 24 F 70 92 M 42 37 F 43 31 F 55 98 F 65 50 M 61 01 M 50 19 F 66 12 F 62 18 M 63 75 F 44 60 M 55 12 F 65 48 M 46 19 M 53 82 F 55 30 F 63 88 F 68 40 F 55 72 F $ 91,000 $ 50,000 $ 31 000 $ 48,000 $ 47,000 $ 90,000 $ 100,000 $ 29,000 $ 53,000 $ 59,000 $ 48,000 $ 89,000 $ 55,000 $ 62,000 $ 100,000 $ 82,000 $ 92,000 $ 83,000 $ 66,000 $ 65,000 $ 33,000 $ 70,000 $ 77,000 $ 97,000 $ 45,000 $ 93,000 $ 58,000 $ 76,000 $ 48,000 $ 41,000 $ 43,000 $ 99,000 E D 30 16,309 30 19,0891 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 25 12,691 10 11,3821 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 2015,767 30 19,195 25 17,579) 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 2015,456 30 19,186 15 10,803 20 14 991 30 20,569 30 19,966 2020,240 25 18,602 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 1,631 1,422 2349 2,471 3,144 1,499 1058 2,123 2,832 2,573 2,047 3067 2,640 2,731 1,628 2,153 2,670 1,489 2,079 2488 2915 3,212 1369 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 45091 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 41 E 4 4 D 2 3 41 A D 4 3 D E 5 Telululululula 19 90 4 Muchache 20 4 30 0 0 2 33 4) 22 5 29 9 0 Question 1 2 pts Tir Att 71 If the Dept is 6007, enter 900, if the Department is 4305, enter 600, if the Department is 4312, enter 350, otherwise enter 200 Copy the function down for the employees Calculate the total Department Bonus for all the employees in cell P1 What is this amount Format as comma style, 0 decimals Question 2 5 pts Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on the Days Absent Calculate the total bonus for all the employees What is this amount Format as comma style 0 decimal Question 3 5 pts Use VLOOKUP to insert the appropriate comment for each employee How many employees have the Good comment Question 4 5 pts If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0 What is the total Format as comma style, 0 decimals Department Bonus If the Dept is 6007, enter 900, if it is 4305, enter 600, if it is 4312, enter 350, otherwise enter 200 Copy the function down for the employees Calculate the total Department Bonus in cell Q1 OR IF AND etc ent Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus AND IF value for each employee based on R etc the Days Absent Calculate the total bonus for all the employees in R1 Comment Use VLOOKUP to insert the appropriate comment for each employee How many employees have the Good comment IF AND OR etc If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0 What is the total Calculate the total in T1 If the Units Made is 17000 or more IF AND OR the Units Rejected is 2000 or OR etc less AND the Rating is A or B enter 1000, otherwise enter 0 What is the total Calculate the total in U1 ID Cc If the 3rd character of the ID IF AND I is a 3,5 or 8 AND the Rating OR etc is A, B, C or D enter 750, otherwise enter 0 Calculate the total in V1 ID Cc If the 3rd character of the ID IF AND I is a 3,5 or 8 AND the Rating OR etc is A, B, C or D enter 750, otherwise enter 0 Calculate the total in V1 If the ID ends with a 2, 4, 6, DIF AND ORTlor 8 and the Days Absent is cc etc 2 or less, enter 500, otherwise the cell should be blank What is the total Calculate the total in W1 RIF AND OR etc If the Department begins with 43 or 60 and the Units Made 19000 or more, enter Yes, otherwise enter No How many Yes are there C D E F G H 1 J K L M N o Q R T U V W Z Age Gender Salary Comment IF AND IF AND First Name Date of Hire Date of Birth Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Department Bonus Days Absent Bonus IF AND OR etc IF AND OR IF AND OR etc etc OR etc OR etc B A B 1 Employee Data 2 3 Employee Last Name ID 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Alboucq 12 11631 Alexander 13 14548 Alvardo $ $ 1 4 B C $ 1 E Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion 24 Jun 85 16 Oct 58 25 Mar 85 28 Jan 55 26 Apr 895 Oct 50 1 Feb 91 21 Dec 64 29 May 79 8 Apr 58 15 Oct 89 22 Apr 70 12 Jan 92 28 May 64 6 Jul 0016 Oct 62 21 Feb 05 26 Mar 76 61 49 F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F $ $ 91,000 50,000 31,000 48,000 47,000 90,000 100,000 29,000 53,000 D 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 01 30 16,309 30 19,089 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 $ D 3 41 $ E A 4 $ $ A 4 X E P Q U Y Z AA BUS308 Quiz1 (1) A B Employee Last Name ID First Name D Date of Hire F Age H Salary Gender Date of Birth M N Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Comment Department Bonus R Days Absent Bonus T IF AND OR etc IF AND OR etc V IF AND OR etc W IF AND OR IF AND OR etc etc B 1 4 B C 1 E D 0 D 3 4 E A 4 4 4 0 A E E A 2 4 4 D C 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 0 28 8 14 7 33 1 32 8 46 6 15 8 16 31 25 01 43 6 27 6 25 9 36 6 22 1 27 4 21 2 23 7 32 91 3 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Albouca 12 11631 Alexander 13 14548 Alvardo 14 14957 Anderson 15 12911 Anderson 16 14048 Ansari 17 13827 Atkinson 18 14765 Bacon Jr 19 13250 Baldwin 20 14923 Balke 21 14675 Barbariol 22 10827 Barnhill 23 14584 Barr 24 10149 Barrett 25 11889 Bartkowski 26 14347 Beck 27 12005 Ben Sachar 28 10069 Benson 29 12061 Berge 30 12833 Berglund 31 12037 Bergman 32 10940 Berry 33 13232 Blakeman 34 14038 Blose 35 11061 Bockman 36 13700 Bogdan HAN Employee Data 2 Anas 24 Jun 85 16 Oct 58 Kim 25 Mar 85 28 Jan 55 Pilar 26 Apr 89 5 Oct 50 Jeff 1 Feb 91 21 Dec 64 Kim 29 May 79 8 Apr 58 Sarah 15 Oct 89 22 Apr 70 Steve 12 Jan 92 28 May 64 Sean 6 Jul 00 16 Oct 62 Marion 21 Feb 05 26 Mar 76 Amy 11 Apr 92 1 Nov 70 Charlie 6 Jun 06 20 Jun 76 Zachary 27 Dec 87 26 Sep 51 Teresa 6 Apr 88 14 Jan 61 Dan 22 Jun 74 15 May 49 Amie 21 Apr 05 24 Nov 77 Wendy 21 Oct 04 15 Dec 76 Angela 16 Feb 96 18 Apr 64 Josh 26 Jul 77 12 Oct 54 Adam 9 Jul 93 8 Apr 59 Holly 14 Mar 95) 30 Jan 70 Joanna 13 Jul 84 28 Feb 54 Bradley 20 Dec 98 5 Feb 58 Ido 21 Sep 93 12 Jul 56 Max 22 Nov 99 2 Sep 75 Karen 1 Jun 97 27 Feb 65 Andreas 19 Mar 88 21 Oct 54 Ken 17 Mar 01 28 Jan 74 Jo 20 Sep 00 14 Jun 66 Synthia 1 Feb 91 21 Dec 64 Cleotilde 11 Sep 8727 May 56 Anne 20 Aug 98 18 Nov 51 Deadra 27 Mar 91 20 Jul 64 61 49F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F 49 44 F 43 80 M 68 55 M 59 24 F 70 92 M 42 37 F 43 31 F 55 98 F 65 50 M 61 01 M 50 19 F 66 12 F 62 18 M 63 75 F 44 60 M 55 12 F 65 48 M 46 19 M 53 82 F 55 30 F 63 88 F 68 40 F 55 72 F $ 91,000 $ 50,000 $ 31 000 $ 48,000 $ 47,000 $ 90,000 $ 100,000 $ 29,000 $ 53,000 $ 59,000 $ 48,000 $ 89,000 $ 55,000 $ 62,000 $ 100,000 $ 82,000 $ 92,000 $ 83,000 $ 66,000 $ 65,000 $ 33,000 $ 70,000 $ 77,000 $ 97,000 $ 45,000 $ 93,000 $ 58,000 $ 76,000 $ 48,000 $ 41,000 $ 43,000 $ 99,000 E D 30 16,309 30 19,0891 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 25 12,691 10 11,3821 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 2015,767 30 19,195 25 17,579) 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 2015,456 30 19,186 15 10,803 20 14 991 30 20,569 30 19,966 2020,240 25 18,602 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 1,631 1,422 2349 2,471 3,144 1,499 1058 2,123 2,832 2,573 2,047 3067 2,640 2,731 1,628 2,153 2,670 1,489 2,079 2488 2915 3,212 1369 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 45091 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 41 E 4 4 D 2 3 41 A D 4 3 D E 5 Telululululula 19 90 4 Muchache 20 4 30 0 0 2 33 4) 22 5 29 9 0 Question 1 2 pts Tir Att 71 If the Dept is 6007, enter 900, if the Department is 4305, enter 600, if the Department is 4312, enter 350, otherwise enter 200 Copy the function down for the employees Calculate the total Department Bonus for all the employees in cell P1 What is this amount Format as comma style, 0 decimals Question 2 5 pts Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on the Days Absent Calculate the total bonus for all the employees What is this amount Format as comma style 0 decimal Question 3 5 pts Use VLOOKUP to insert the appropriate comment for each employee How many employees have the Good comment Question 4 5 pts If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0 What is the total Format as comma style, 0 decimals

Question

Needing help with questions 1 4 Please   Department Bonus If the Dept is 6007, enter 900, if it is 4305, enter 600, if it is 4312, enter 350, otherwise enter 200  Copy the function down for the employees  Calculate the total Department Bonus in cell Q1  OR IF AND etc  ent Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus AND IF value for each employee based on R etc  the Days Absent  Calculate the total bonus for all the employees in R1    Comment Use VLOOKUP to insert the appropriate comment for each employee  How many employees have the Good comment  IF AND OR etc  If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0  What is the total  Calculate the total in T1  If the Units Made is 17000 or more IF AND OR the Units Rejected is 2000 or    OR etc  less AND the Rating is A or B enter 1000, otherwise enter 0  What is the total  Calculate the total in U1  ID Cc  If the 3rd character of the ID IF AND I   is a 3,5 or 8 AND the Rating OR etc  is A, B, C or D enter 750, otherwise enter 0  Calculate the total in V1  ID Cc  If the 3rd character of the ID IF AND I   is a 3,5 or 8 AND the Rating OR etc  is A, B, C or D enter 750, otherwise enter 0  Calculate the total in V1  If the ID ends with a 2, 4, 6, DIF AND ORTlor 8 and the Days Absent is cc  etc  2 or less, enter 500, otherwise the cell should be blank  What is the total  Calculate the total in W1  RIF AND OR etc  If the Department begins with 43 or 60 and the Units Made 19000 or more, enter Yes, otherwise enter No  How many Yes are there  C D E F G H 1 J K L M N o Q R T U V W Z Age Gender Salary Comment IF AND IF AND First Name Date of Hire Date of Birth Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Department Bonus Days Absent Bonus IF AND OR etc  IF AND OR IF AND OR etc  etc  OR etc  OR etc  B A B 1 Employee Data 2 3 Employee Last Name ID 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Alboucq 12 11631 Alexander 13 14548 Alvardo $ $ 1 4 B C $ 1 E Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion 24 Jun 85 16 Oct 58 25 Mar 85 28 Jan 55 26 Apr 895 Oct 50 1 Feb 91 21 Dec 64 29 May 79 8 Apr 58 15 Oct 89 22 Apr 70 12 Jan 92 28 May 64 6 Jul 0016 Oct 62 21 Feb 05 26 Mar 76 61 49 F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F $ $ 91,000 50,000 31,000 48,000 47,000 90,000 100,000 29,000 53,000 D 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 01 30 16,309 30 19,089 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 $ D 3 41 $ E A 4 $ $ A 4 X E P Q U Y Z AA BUS308 Quiz1 (1) A B Employee Last Name ID First Name D Date of Hire F Age H Salary Gender Date of Birth M N Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Comment Department Bonus R Days Absent Bonus T IF AND OR etc  IF AND OR etc  V IF AND OR etc  W IF AND OR IF AND OR etc  etc  B 1 4 B C 1 E D 0 D 3 4 E A 4 4 4 0 A E E A 2 4 4 D C 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 0 28 8 14 7 33 1 32 8 46 6 15 8 16 31 25 01 43 6 27 6 25 9 36 6 22 1 27 4 21 2 23 7 32 91 3 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Albouca 12 11631 Alexander 13 14548 Alvardo 14 14957 Anderson 15 12911 Anderson 16 14048 Ansari 17 13827 Atkinson 18 14765 Bacon Jr  19 13250 Baldwin 20 14923 Balke 21 14675 Barbariol 22 10827 Barnhill 23 14584 Barr 24 10149 Barrett 25 11889 Bartkowski 26 14347 Beck 27 12005 Ben Sachar 28 10069 Benson 29 12061 Berge 30 12833 Berglund 31 12037 Bergman 32 10940 Berry 33 13232 Blakeman 34 14038 Blose 35 11061 Bockman 36 13700 Bogdan HAN Employee Data 2 Anas 24 Jun 85 16 Oct 58 Kim 25 Mar 85 28 Jan 55 Pilar 26 Apr 89 5 Oct 50 Jeff 1 Feb 91 21 Dec 64 Kim 29 May 79 8 Apr 58 Sarah 15 Oct 89 22 Apr 70 Steve 12 Jan 92 28 May 64 Sean 6 Jul 00 16 Oct 62 Marion 21 Feb 05 26 Mar 76 Amy 11 Apr 92 1 Nov 70 Charlie 6 Jun 06 20 Jun 76 Zachary 27 Dec 87 26 Sep 51 Teresa 6 Apr 88 14 Jan 61 Dan 22 Jun 74 15 May 49 Amie 21 Apr 05 24 Nov 77 Wendy 21 Oct 04 15 Dec 76 Angela 16 Feb 96 18 Apr 64 Josh 26 Jul 77  12 Oct 54 Adam 9 Jul 93 8 Apr 59 Holly 14 Mar 95) 30 Jan 70 Joanna 13 Jul 84 28 Feb 54 Bradley 20 Dec 98  5 Feb 58 Ido 21 Sep 93 12 Jul 56 Max 22 Nov 99 2 Sep 75 Karen 1 Jun 97 27 Feb 65 Andreas 19 Mar 88 21 Oct 54 Ken 17 Mar 01 28 Jan 74 Jo 20 Sep 00 14 Jun 66 Synthia 1 Feb 91 21 Dec 64 Cleotilde 11 Sep 8727 May 56 Anne 20 Aug 98 18 Nov 51 Deadra 27 Mar 91 20 Jul 64 61 49F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F 49 44 F 43 80 M 68 55 M 59 24 F 70 92 M 42 37 F 43 31 F 55 98 F 65 50 M 61 01 M 50 19 F 66 12 F  62 18 M 63 75 F 44 60 M 55 12 F 65 48 M 46 19 M 53 82 F 55 30 F 63 88 F 68 40 F 55 72 F $ 91,000 $ 50,000 $ 31 000 $ 48,000 $ 47,000 $ 90,000 $ 100,000 $ 29,000 $ 53,000 $ 59,000 $ 48,000 $ 89,000 $ 55,000 $ 62,000 $ 100,000 $ 82,000 $ 92,000 $ 83,000 $ 66,000 $ 65,000 $ 33,000 $ 70,000 $ 77,000 $ 97,000 $ 45,000 $ 93,000 $ 58,000 $ 76,000 $ 48,000 $ 41,000 $ 43,000 $ 99,000 E D 30 16,309 30 19,0891 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 25 12,691 10 11,3821 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 2015,767 30 19,195 25 17,579) 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 2015,456 30 19,186 15 10,803 20 14 991 30 20,569 30 19,966 2020,240 25 18,602 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 1,631 1,422 2349 2,471 3,144 1,499 1058 2,123 2,832 2,573 2,047 3067 2,640 2,731 1,628 2,153 2,670 1,489 2,079 2488 2915 3,212 1369 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 45091 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 41 E 4 4 D 2 3 41 A D 4 3 D E 5 Telululululula 19 90 4 Muchache 20 4 30 0 0 2 33 4) 22 5 29 9 0 Question 1 2 pts Tir Att 71 If the Dept is 6007, enter 900, if the Department is 4305, enter 600, if the Department is 4312, enter 350, otherwise enter 200  Copy the function down for the employees  Calculate the total Department Bonus for all the employees in cell P1  What is this amount  Format as comma style, 0 decimals Question 2 5 pts Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on the Days Absent  Calculate the total bonus for all the employees  What is this amount  Format as comma style 0 decimal  Question 3 5 pts Use VLOOKUP to insert the appropriate comment for each employee  How many employees have the Good comment  Question 4 5 pts If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0  What is the total  Format as comma style, 0 decimals  Department Bonus If the Dept is 6007, enter 900, if it is 4305, enter 600, if it is 4312, enter 350, otherwise enter 200  Copy the function down for the employees  Calculate the total Department Bonus in cell Q1  OR IF AND etc  ent Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus AND IF value for each employee based on R etc  the Days Absent  Calculate the total bonus for all the employees in R1    Comment Use VLOOKUP to insert the appropriate comment for each employee  How many employees have the Good comment  IF AND OR etc  If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0  What is the total  Calculate the total in T1  If the Units Made is 17000 or more IF AND OR the Units Rejected is 2000 or    OR etc  less AND the Rating is A or B enter 1000, otherwise enter 0  What is the total  Calculate the total in U1  ID Cc  If the 3rd character of the ID IF AND I   is a 3,5 or 8 AND the Rating OR etc  is A, B, C or D enter 750, otherwise enter 0  Calculate the total in V1  ID Cc  If the 3rd character of the ID IF AND I   is a 3,5 or 8 AND the Rating OR etc  is A, B, C or D enter 750, otherwise enter 0  Calculate the total in V1  If the ID ends with a 2, 4, 6, DIF AND ORTlor 8 and the Days Absent is cc  etc  2 or less, enter 500, otherwise the cell should be blank  What is the total  Calculate the total in W1  RIF AND OR etc  If the Department begins with 43 or 60 and the Units Made 19000 or more, enter Yes, otherwise enter No  How many Yes are there  C D E F G H 1 J K L M N o Q R T U V W Z Age Gender Salary Comment IF AND IF AND First Name Date of Hire Date of Birth Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Department Bonus Days Absent Bonus IF AND OR etc  IF AND OR IF AND OR etc  etc  OR etc  OR etc  B A B 1 Employee Data 2 3 Employee Last Name ID 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Alboucq 12 11631 Alexander 13 14548 Alvardo $ $ 1 4 B C $ 1 E Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion 24 Jun 85 16 Oct 58 25 Mar 85 28 Jan 55 26 Apr 895 Oct 50 1 Feb 91 21 Dec 64 29 May 79 8 Apr 58 15 Oct 89 22 Apr 70 12 Jan 92 28 May 64 6 Jul 0016 Oct 62 21 Feb 05 26 Mar 76 61 49 F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F $ $ 91,000 50,000 31,000 48,000 47,000 90,000 100,000 29,000 53,000 D 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 01 30 16,309 30 19,089 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 $ D 3 41 $ E A 4 $ $ A 4 X E P Q U Y Z AA BUS308 Quiz1 (1) A B Employee Last Name ID First Name D Date of Hire F Age H Salary Gender Date of Birth M N Rating Years of Vacation Units Units Days Department Service Days Made Rejected Absent Comment Department Bonus R Days Absent Bonus T IF AND OR etc  IF AND OR etc  V IF AND OR etc  W IF AND OR IF AND OR etc  etc  B 1 4 B C 1 E D 0 D 3 4 E A 4 4 4 0 A E E A 2 4 4 D C 35 6 35 9 31 8 30 0 41 7 31 3 29 1 20 6 16 0 28 8 14 7 33 1 32 8 46 6 15 8 16 31 25 01 43 6 27 6 25 9 36 6 22 1 27 4 21 2 23 7 32 91 3 4 5 13816 Abbar 6 13832 Abercrombie 7 10774 Ackerman 8 11737 Adell 9 14470 Akers 10 10598 Akhtar 11 11194 Albouca 12 11631 Alexander 13 14548 Alvardo 14 14957 Anderson 15 12911 Anderson 16 14048 Ansari 17 13827 Atkinson 18 14765 Bacon Jr  19 13250 Baldwin 20 14923 Balke 21 14675 Barbariol 22 10827 Barnhill 23 14584 Barr 24 10149 Barrett 25 11889 Bartkowski 26 14347 Beck 27 12005 Ben Sachar 28 10069 Benson 29 12061 Berge 30 12833 Berglund 31 12037 Bergman 32 10940 Berry 33 13232 Blakeman 34 14038 Blose 35 11061 Bockman 36 13700 Bogdan HAN Employee Data 2 Anas 24 Jun 85 16 Oct 58 Kim 25 Mar 85 28 Jan 55 Pilar 26 Apr 89 5 Oct 50 Jeff 1 Feb 91 21 Dec 64 Kim 29 May 79 8 Apr 58 Sarah 15 Oct 89 22 Apr 70 Steve 12 Jan 92 28 May 64 Sean 6 Jul 00 16 Oct 62 Marion 21 Feb 05 26 Mar 76 Amy 11 Apr 92 1 Nov 70 Charlie 6 Jun 06 20 Jun 76 Zachary 27 Dec 87 26 Sep 51 Teresa 6 Apr 88 14 Jan 61 Dan 22 Jun 74 15 May 49 Amie 21 Apr 05 24 Nov 77 Wendy 21 Oct 04 15 Dec 76 Angela 16 Feb 96 18 Apr 64 Josh 26 Jul 77  12 Oct 54 Adam 9 Jul 93 8 Apr 59 Holly 14 Mar 95) 30 Jan 70 Joanna 13 Jul 84 28 Feb 54 Bradley 20 Dec 98  5 Feb 58 Ido 21 Sep 93 12 Jul 56 Max 22 Nov 99 2 Sep 75 Karen 1 Jun 97 27 Feb 65 Andreas 19 Mar 88 21 Oct 54 Ken 17 Mar 01 28 Jan 74 Jo 20 Sep 00 14 Jun 66 Synthia 1 Feb 91 21 Dec 64 Cleotilde 11 Sep 8727 May 56 Anne 20 Aug 98 18 Nov 51 Deadra 27 Mar 91 20 Jul 64 61 49F 65 21 F 69 52 F 55 30 F 62 01 F 49 96 F 55 87 F 57 48 M 44 03 F 49 44 F 43 80 M 68 55 M 59 24 F 70 92 M 42 37 F 43 31 F 55 98 F 65 50 M 61 01 M 50 19 F 66 12 F  62 18 M 63 75 F 44 60 M 55 12 F 65 48 M 46 19 M 53 82 F 55 30 F 63 88 F 68 40 F 55 72 F $ 91,000 $ 50,000 $ 31 000 $ 48,000 $ 47,000 $ 90,000 $ 100,000 $ 29,000 $ 53,000 $ 59,000 $ 48,000 $ 89,000 $ 55,000 $ 62,000 $ 100,000 $ 82,000 $ 92,000 $ 83,000 $ 66,000 $ 65,000 $ 33,000 $ 70,000 $ 77,000 $ 97,000 $ 45,000 $ 93,000 $ 58,000 $ 76,000 $ 48,000 $ 41,000 $ 43,000 $ 99,000 E D 30 16,309 30 19,0891 30 20 643 30 15,523 30 17,939 30 13,602 25 15,728 2016,309 15 14,851 25 12,691 10 11,3821 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 2015,767 30 19,195 25 17,579) 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 2015,456 30 19,186 15 10,803 20 14 991 30 20,569 30 19,966 2020,240 25 18,602 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 1,631 1,422 2349 2,471 3,144 1,499 1058 2,123 2,832 2,573 2,047 3067 2,640 2,731 1,628 2,153 2,670 1,489 2,079 2488 2915 3,212 1369 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 45091 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 41 E 4 4 D 2 3 41 A D 4 3 D E 5 Telululululula 19 90 4 Muchache 20 4 30 0 0 2 33 4) 22 5 29 9 0 Question 1 2 pts Tir Att 71 If the Dept is 6007, enter 900, if the Department is 4305, enter 600, if the Department is 4312, enter 350, otherwise enter 200  Copy the function down for the employees  Calculate the total Department Bonus for all the employees in cell P1  What is this amount  Format as comma style, 0 decimals Question 2 5 pts Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on the Days Absent  Calculate the total bonus for all the employees  What is this amount  Format as comma style 0 decimal  Question 3 5 pts Use VLOOKUP to insert the appropriate comment for each employee  How many employees have the Good comment  Question 4 5 pts If the Rating is A, B or D and the Department is 4302, 4303 or 6007, and the Units Rejected is less than 2500, enter 1000, otherwise enter 0  What is the total  Format as comma style, 0 decimals

Accepted Answer

The Answer is in the image, click to view ...

Question

Needing help with questions 1-4 Please!! Department Bonus If the Dept is 6007, enter 900, if it is 4305, enter 600, if it is 4312,

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Principles Of Commodity Economics And Finance

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question