Department Bonus If the Dept is 6007, enter 900, if it is 4305, enter 600, if...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service B B E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ B B ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service B B E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ B B ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ B B ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service B B E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ B B ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service B B E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ B B ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71 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. -nt Days Absent Bonus Use the VLOOKUP function to enter the appropriate Bonus value for each employee based on R etc. the Days Absent. Calculate the total bonus for all the employees in R1. AND IF 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. D . IF AND OR etc. If the Units Made is 17000 or more IOR the Units Rejected is 2000 or less AND the Rating is A or B enter 1000, otherwise enter 0. What is the total? Calculate the total in U1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D CC. IF AND IF AND OR etc. If the 3rd character of the ID I# is a 3, 5 or 8 AND the Rating is A, B, C or D enter 750, otherwise enter 0. Calculate the total in V1. D IF AND OR C. etc. If the ID ends with a 2, 4, 6, or 8 and the Days Absent is 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? A 1 Employee Data 2 3 4 5 6 7 8 9 LO 11 12 13 B Employee Last Name ID 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo с D First Date of Name Hire E Date of Birth Anas Kim Pilar Jeff 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-Oct-50 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 F Age G Gender 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 $ $ $ $ $ $ $ $ $ H Salary 1 J 91,000 B 50,000 B 31,000 C 48,000 E 47,000 D 90,000 D 100,000 E 29,000 A 53,000 A Rating Years of Vacation Service Days K 35.6 35.9 31.8 30.0 41.7 31.3 29.1 20.6 16.0 L 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 M 20 16,309 15 14,851 Units Units Days Department Made Rejected Absent N 2,370 2,815 3,063 2,244 2,471 1,937 2,277 2,290 3126 O 1 4 1 3 0 3 4 4 4 4302 5894 5894 4308 4303 5894 4308 4308 6007 P 0 R Department Days Bonus Absent Bonus S Comment T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z 4 5 6 BUS308-Quiz1 (1) A B Employee Last Name ID 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 44 13816 Abbar 13832 Abercrombie 10774 Ackerman 11737 Adell 14470 Akers 10598 Akhtar 11194 Alboucq 11631 Alexander 14548 Alvardo 14957 Anderson 12911 Anderson 14048 Ansari 13827 Atkinson 14765 Bacon Jr. 13250 Baldwin 14923 Balke 14675 Barbariol 10827 Barnhill 14584 Barr 10149 Barrett 11889 Bartkowski 14347 Beck 12005 Ben-Sachar 10069 Benson 12061 Berge 12833 Berglund 12037 Bergman 10940 Berry 13232 Blakeman 14038 Blose 11061 Bockman 13700 Bogdan Employee Data C First Name D Date of Hire Anas Kim Pilar Jeff Kim Sarah Steve Sean Marion E Date of Birth 24-Jun-85 16-Oct-58 25-Mar-85 28-Jan-55 26-Apr-89 5-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-00 16-Oct-62 21-Feb-05 26-Mar-76 11-Apr-92 1-Nov-70 6-Jun-06 20-Jun-76 27-Dec-87 26-Sep-51 6-Apr-88 14-Jan-61 22-Jun-74 15-May-49 21-Apr-05 24-Nov-77 21-Oct-04 15-Dec-76 16-Feb-96 18-Apr-64 26-Jul-77 12-Oct-54 9-Jul-93 8-Apr-59 14-Mar-95 30-Jan-70 13-Jul-84 28-Feb-54 20-Dec-98 5-Feb-58 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-87 27-May-56 Anne 20-Aug-98 18-Nov-51 Deadra 27-Mar-91 20-Jul-64 Amy Charlie Zachary Teresa Dan Amie Wendy Angela Josh Adam Holly Joanna Bradley Ido F G Age Gender 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 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 33,000 70,000 77,000 D $ $ $ $ A GA GA $ H Salary Rating Years of Vacation Units Service E 91,000 50,000 31,000 48,000 47,000 D 90,000 D 100,000 F 29,000 A 53,000 A 59,000 A 48,000 E 89,000 E 55,000 A 62,000 100,000 82,000 92,000 83,000 E 66,000 A 65,000 A D C E D D A $ B B ادام C olohulalahulolololo 97,000 45,000 F 93,000 A D 58,000 A 76,000 E 48,000 A 41,000 $ 43,000 $ D A 99,000 A 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.3 25.0 43.6 27.6 25.9 36.6 22.1 27.4 21.2 23.7 32.9 19.9 20.4 30.0 33.4 22.5 29.9 Days Made Rejected Absent 30 16,309 30 19,089 30 20,643 30 15,523 30 17,939 30 13,602 25 15,728 20 16,309 15 14,851 25 12,691 10 11,382 30 15,686 30 16,941 30 21,144 15 10,867 15 15,058 20 15,767 30 19,195 25 17,579 25 12,963 30 19,849 20 18,000 25 18,565 20 11,670 20 15,456 30 19,186 M N O Units Days Department 15 10,803 20 14,991 30 20,569 30 19,966 20 20,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 4 1 0 3 4 41 4 4 0 2 4 4 3 2 4 4 4 2 3 4 4 3 1 5 3 4 0 2 0 4302 5894 5894 4308 4303 5894 4308 4308 6007 4308 4509 6007 4372 4509 4308 6007 4509 4312 4372 4302 6008 4312 4509 4509 4302 4370 4302 4302 6008 6005 4509 6006 P Q R Department Days Comment Bonus Absent Bonus T IF AND OR etc. U IF AND OR etc. V W X IF AND IF AND OR IF AND OR OR etc. etc. etc. Y Z - AA X D Question 1 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 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 Use VLOOKUP to insert the appropriate comment for each employee. How many employees have the Good comment? Question 4 2 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 O. What is the total? Format as comma style, 0 decimals. 5 pts 5 pts 5 pts Tir Att 71
Expert Answer:
Answer rating: 100% (QA)
Screenshot is also attached You didnt provided whole data he... View the full answer
Related Book For
Discrete and Combinatorial Mathematics An Applied Introduction
ISBN: 978-0201726343
5th edition
Authors: Ralph P. Grimaldi
Posted Date:
Students also viewed these finance questions
-
In this mini-case, you will determine overall materiality as well as tolerable misstatement amounts for balance sheet accounts of EarthWear Clothiers, Inc. Most auditing firms use a simple approach...
-
Develop an Excel model for Robert's Chiropractic Clinic - use the scenario provided below. Robert Berns runs a Chiropractic Clinic in Belle Jardin in St. Louis. His annual fixed operating costs are...
-
You and a business partner opened a fitness gym three years ago. Your partner oversees managing the operations of the gym, ensuring the right equipment is on hand, maintenance is conducted, and the...
-
In Pissarides's view of labor markets (job matching model), the focus is on finding a good ________. a. level of TFP (A) b. supply of money (M). c. match d. Wage
-
Solve the following proportions for the unknown quantities 10.12 5 3 7 18
-
Fit an exponential model to Plot the data and the equation on both standard and semi-logarithmic graphpaper. 1.2 23 x0.4 08 800 975 1500 1950 2900 3600 2 1.6
-
A contract is created to refurbish a luxury yacht: new color schemes, new furniture, new wall and floor coverings, new light fixtures, and window treatmentsthe whole works. Of course, it is not just...
-
Search for Unrecorded Liabilities. The list of vouchers payable for Potter's Magic Shoppe at December 31 is as follows: Required: a. Prepare an audit plan for the audit of unrecorded liabilities for...
-
Sid needs 0.8 meters of canvas material to make a carry-all bag for his wheelchair. If canvas is $11.64 per meter, how much will Sid spend? (Note that $11.64 per meter is the same as $11.64 for one...
-
Assume that Chapman Company acquired Abernethy's common stock for $490,000 in cash. As of January 1, 2017, Abernethy's land had a fair value of $90,000, its buildings were valued at $160,000, and its...
-
The Old English Garden Shop is a retail store that sells garden equipment, furniture, and supplies. Its credit purchases and purchases returns and allowances for July are listed below. The general...
-
Consider the circuit shown below. v(t) R C Here R = 3 KQ, C = 6 nF, and 1=1 mH. The voltage source is vt) (12 V) sin(w), where w=39 krad/s. = The current through the source is (t) = f sin(wt+0),...
-
If f(x) = f'(x) = x - 3 x +3 3x (x + 3) f'(3) = 33 (3+3) find:
-
Suppose the current yield on a one-year zero-coupon bond is 4 %, while the yield on a five-year zero-coupon bond is 6 %. Neither bond has any risk of default. Suppose you plan to invest for one year....
-
To analyze a stock, you have estimated the single-index model: ri - rf = alpha + beta x (ri - rm) + ei, for the stock using a market index portfolio. The following table summarizes the model...
-
Find the value for k so that the function will be continuous at x = -5. f(x) 5x+45x + 100 x+5 -7 3x2 12x + 12+ k if x < -5 if x -5
-
Under federal income tax rules, how are gains and losses on the trade-in of a like-kind asset ? a. gains and losses are recognized. b. gains are recognized but losses are not recognized. c. neither...
-
A heat engine has a heat input of 3 Ã 104 Btu/h and a thermal efficiency of 40 percent. Calculate the power it will produce, in hp. Source 3 x 10 Btu/h 40% HE Sink
-
Let G = (V, E) be an undirected graph with subset I of V an independent set. For each a I and each Hamilton cycle C for G, there will be deg (a) - 2 edges in E that are incident with a and not in C....
-
Let A = {x, a, b, c, d}. (a) How many closed binary operations f on A satisfy f(a, b) = c? (b) How many of the functions f in part (a) have x as an identity? (c) How many of the functions f in part...
-
Provide the missing reasons for the steps verifying the following argument: Steps Reasons (1) x [p(x) ¨ q(x)] Premise (2) x ¬p(x) Premise (3) ¬ p(a) Step (2) and the definition of the...
-
Consider a strictly risk averse agent endowed with initial wealth \(w_{0}\) and with a strictly increasing and twice differentiable utility function. Let \(r_{f}\) and \(\tilde{r}\) denote the return...
-
Consider a quadratic utility function \(u(x)=x-\frac{b}{2} x^{2}\), an initial wealth \(w_{0}=100\), a risk free rate \(r_{f}=1.1\) and a risky asset with expected return...
-
Consider the optimal portfolio choice problem in the presence of \(N\) risky assets with returns \(\left(\tilde{r}_{1}, \ldots, \tilde{r}_{N} ight)\) and of a risk free asset with return \(r_{f}>0\)....
Study smarter with the SolutionInn App