subject

A company evaluates new graduates for positions according to three criteria. 1. If the candidate has a GPA of at least 3.3, the candidate receives 1 point. 2. On the interview, candidates who score 7 or 8 (out of 10) receives 1 point; candidates who score 9 or 10 receive 2 points. Scores below 7 get no points. 3. The company gives an aptitude test. 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. Complete the model that was started on the Problem 2 worksheet, to allow the Human Resources Department to enter in a candidate’s name, GPA, interview score, and aptitude score (in the range E6:H6) as inputs, and determines the employment decision. Specifically:  Enter values in the range B10:C12 so you can use it for determining the number of interview points using vlookup.  Enter values in the range B20:C22 so you can use it for determining the position offered for a given total rating, using vlookup.  Enter a formula in F9 to determine the total rating for the candidate.  Enter a formula in cell F10 to determine the position to be offered.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 21:00
Select all that apply. what types of documents can be created using word-processing software? business newsletters letters of application presentation slideshows customer databases
Answers: 1
question
Computers and Technology, 22.06.2019 06:50
Match the personality traits with their description
Answers: 1
question
Computers and Technology, 22.06.2019 10:00
Create a word problem that involves calculating the volume and surface area of a three-dimensional object. cube: surface area 6 s2 , volume s3
Answers: 3
question
Computers and Technology, 22.06.2019 17:00
The two main ways in which marketers address the competition with their strategies are by satisfying a need better than a competition and by
Answers: 2
You know the right answer?
A company evaluates new graduates for positions according to three criteria. 1. If the candidate has...
Questions
question
Computers and Technology, 10.11.2020 14:40
question
Chemistry, 10.11.2020 14:40
question
Physics, 10.11.2020 14:40
question
Biology, 10.11.2020 14:40
Questions on the website: 13722360