EXERCISE 2 – Company Recruitment

EXERCISE 2 – Company Recruitment

w,e,c,h,a,t : help-assignment

A company evaluates new graduates for positions according to three criteria. If the candidate has a Grade Point Average (GPA) of at least 3.3, the candidate receives 1 point. On the interview, candidates who score 7 or 8 (out of 10) receive 1 point; candidates who score 9 or 10 receive 2 points. The company gives an aptitude test as well. A candidate who scores above 85 gets 1 point.

The company adds up the points to obtain a candidate’s rating. A candidate who receives a rating of 0, 1, or 2 points is not given a job offer. A candidate who receives 3 points is given an offer as a Junior Salesperson. A candidate who receives 4 points is given an offer as a Fast-Track Manager in Training.

Create a worksheet that allows the Human Resources Department to enter in a candidate’s name, GPA, interview score, and aptitude score and determines the employment decision.

Use the following information to test your formula

• John, GPA 3.5, Interview score 9, Aptitude score 86

• Lin, GPA 2.0, Interview score 8, Aptitude score 90

• Sandy, GPA 3.7, Interview score 7, Aptitude score 86