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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 05:10, kellysimkin6196
Read the code below. what will the computer print if the input for year_variable is 1700? if year_variable == 1776: print("your answer is correct. the declaration of independence was signed in “year_variable”.") elif year_variable < 1776: compute_variable = 1776 - year_variable. print("add “compute_variable“ years to your answer for the correct answer.") elif year_variable > 1776: compute_variable = year_variable - 1776 print("subtract “compute_variable” years from your answer for the correct answer.")
Answers: 1
image
Computers and Technology, 22.06.2019 13:00, mariahrpoulin9630
Which part of the cpu accepts data?
Answers: 1
image
Computers and Technology, 22.06.2019 18:30, cascyrio2002
What is outfitting a workplace with video in a technology
Answers: 2
image
Computers and Technology, 23.06.2019 16:30, saintsfan2004
How to do this programming flowchart?
Answers: 3
You know the right answer?
A company evaluates new graduates for positions according to three criteria. 1. If the candidate has...

Questions in other subjects:

Konu
Mathematics, 31.07.2019 05:40