1. Open the file WWC Hiring Analysis and save a new copy.
2. For Cells I4:I12, put in a formula to determine if any of the criteria below is invalid:
   • College GPA is less than 1.5
   • College GPA is greater than 4.0
   • Major code is less than 1
   • Major code is greater than 100
   • Employment Score is less than 300
   • Employment Score is greater than 800
3. In Cells J4:J12, put in a formula to determine if any of the students are automatically disqualified based on the following criteria:
   • The have an invalid score/major (Column I)
   • GPA is less than 3.0
   • References is less than 2
   • Employment score is less than 600
   • Personal Interview Rating is less than 3
4. In Cells K4:K12, put in a formula to determine if any of the students were not automatically disqualified.
5. In Cells L4:L12, put in a formula to determine if any of the students meet all of the criteria listed below and are automatically hired:
   • They are not automatically disqualified (Column K)
   • College GPA is greater than 3.8
   • Major code is greater than or equal to 1
   • Major code is less than or equal to 25
   • School Rank is less than or equal to 50
   • Employment Exam Score is greater than 720
   • Personal Interview Rating is greater than or equal to 4
   • They have work experience
6. In Cells M4:M12, put in a formula to determine if any of the students were not automatically hired.
7. In Cells N4:N12, put in a formula to determine if an automated decision has not been decided (i.e. has the student been not automatically disqualified and hired?)
8. In Cells I14:N14, put in a formula to determine if all values are true
9. In Cells I15:N15, put in a formula to determine if any values are true
10. In Cells I16:N16, put in a formula to count the number of scores if they are true.
11. Use Conditional Formatting to highlight any cell in I16:N16 that is greater than 3. (Use any color you wish).
12. Use Conditional Formatting to add data bars to cells E4:E12
13. Save and close the file.

Extra Credit Opportunity (3 Points)

In Cell A19, put in an IF formula that will determine if the average GPA is greater than or less than 3.5. If the value is True, it should say Higher than 3.5. If the value is False, it should say Lower than 3.5. This is an all or nothing opportunity. You will either earn 3 points or 0 points.