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, 23.06.2019 03:00
What are the different parts of computer
Answers: 2
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. a company wants to use online methods to target more customers. it decides to conduct a market research by collecting the data of a few customers with their consent. they want to track data of the sites that their customers frequently visit. which software can the company? a. spyware b. bots c. adware d. trojan horse e. rootkits
Answers: 1
question
Computers and Technology, 23.06.2019 21:30
Write a fragment of code that reads in strings from standard input, until end-of-file and prints to standard output the largest value. you may assume there is at least one value. (cascading/streaming logic, basic string processing)
Answers: 3
question
Computers and Technology, 24.06.2019 18:30
These factors limit the ability to attach files to e-mail messages. location of sender recipient's ability to open file size of file type of operating system used
Answers: 1
You know the right answer?
A company evaluates new graduates for positions according to three criteria. 1. If the candidate has...
Questions
question
Mathematics, 17.06.2021 17:00
question
Mathematics, 17.06.2021 17:00
question
Biology, 17.06.2021 17:00
Questions on the website: 13722363