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 18:00
Which virus-infecting components are email messages prone to carry? one of the problems associated with the use of email communication is that email messages are prone to carry virus-infecting .
Answers: 3
question
Computers and Technology, 23.06.2019 11:30
Auser is given read permission to a file stored on an ntfs-formatted volume. the file is then copied to a folder on the same ntfs-formatted volume where the user has been given full control permission for that folder. when the user logs on to the computer holding the file and accesses its new location via a drive letter, what is the user's effective permission to the file? a. read b. full control c. no access d. modify e. none of the above
Answers: 1
question
Computers and Technology, 23.06.2019 14:00
What is html ? give a small description about html
Answers: 2
question
Computers and Technology, 24.06.2019 11:00
Each row in a database is a set of unique information called a(n) ? a.) table. b.) record. c.) object. d.) field.
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
English, 04.06.2021 19:10
question
English, 04.06.2021 19:10
question
Mathematics, 04.06.2021 19:10