In W10: Use the appropriate function to calculate the average Salary for female employees from Department 5894 who have an E rating?
In X10: Calculate how many employees have a Salary of Less than $80,000 and are from Department 4302 and have D rating?
In V10: use the MATCH function to return the Row# in which 21,982 can be found in the range of Units Made values?
Use the INDEX function and the Row number from the MATCH function to return the First Name of the employee who had 21,982 Units Made?
Filter the table to show Female employees from Departments 4302, 4308 and 5894 with A or B Rating. What is the new average Units Made in AA10?
A B D E F G H 1 J K L M 1 Employee Data Bonus Days Absent 0 2 3 1 4 2 5 3 $ 800.00 $ 400.00 $ 200.00 $ 100.00 $ 20.00 6 Date 4 01-May-20 Rejection Rate 7 1.05% 5 8 9 10 194 11 12 Employee Last Name First Name Department Gender Salary Rating Date of Birth Date of Hire Units Made Units Rejected F Years of Days Service Absent ID 13 14 B 34.9 24-Jun-85 174 13816 Abbar 13832 Abercrombie 10774 Ackerman Anas Kim 1 4 15 B 35.1 25-Mar-85 215 16 31.0 1 173 Pilar Jeff 26-Apr-89 01-Feb-91 17 11737 Adell E 29.3 3 175 16-Oct-58 28-Jan-55 05-Oct-50 21-Dec-64 08-Apr-58 22-Apr-70) 28-May-64 18 14470 Akers D 41.0 0 170 29-May-79 15-Oct-89 19 D 91,000 50,000 31,000 48,000 47,000 90,000 100,000 29,000 53,000 59,000 48,000 30.6 3 175 4302 F 58947 5894 F 4308 F 430317 5894 F 4308 F 4308 M 6007 F 430817 4509M 60071M $ $ $ $ $ $ $ $ $ $ $ S 20 16,557 20,448 16,453 16,613 16,223 16,646 15,564 19,462 20,533) 20,2701 16,685 19.220 E 10598 Akhtar 11194 Albouca 11631 Alexander 14548 Alvardo 28.3 Kim Sarah Steve Sean Marion Amy 4 12-Jan-92 163 21 19.8 4 16-Oct-62 06-Jul-00 204 22 15.2 4 21-Feb-05 216 26-Mar-76 01-Nov-70 23 14957 Anderson A 28.1 4 213 11-Apr-92 06-Jun-06 24 Charlie E 13.9 0 20-Jun-76 175 12911 Anderson 14048 Ansari 25 Zachary 89.000 F 32.4 2 26-Sen-51 27-Dec-87 202 L M N o P Q R S T U V w 1 2 3 4 5 6 7 8 9 10 194 8,500,000 36 129 58 465 235,400 242,000 164,180 11 12 hits Made Units Rejected Net Units Birth Month Birth Year Age in Days Age In Years Days Rating Department Bonus Bonus Absent 13 Bonus 14 174 10 1958 6 0.02 300 1,000 800 15 215 1 66 0.18 300 400 100 16 173 10 1955 1950) 1964 71 0.19 300 400 800 16,557 20,448 16,453 16,613 16,223 16,646 15,564 17 175 12 57 0.15 300 800 200 18 170 4 1958 63 0.17 300 400 1,000 19 175 4 1970 51 0.14 300 400 200 16,383 20,233 16,280 16,438 16,053 16,471 15,401 19,258 20,317 20,057 16,510 19,018 20 163 5 1964 57 0.16 300 800 100 21 19,462 204 10 1962 59 0.16 1,000 800 100 22 216 3 1976 45 0.12 400 100 1,000 1,000 23 213 11 1970 51 0.14 800 100 20,533 20,270 16,685 19,220 24 175 6 1976 45 0.12 300 400 1,000 25 202 9 1951 70 0.19 300 400 400 Employee Data Advanced Filter + Ready ur 150%
