Please write out the formulas for the following sections: Work experience, not Automatically hired, not automatically disqualified, and no Decision. Please use the instrutions and cheat sheet to help figure out the formulas. please show work below!

Pro Case Hum Resa Level 1 - Evaluating Job Applicants for Winston, Winston & Coombs Winston, Winston & Coombs. The firm has recently increased its client base and hired You work in the Human Resources Department or simply HR) for the accounting firm several university graduates for entry-level positions. The HR manager has established a academic performance and work experience, as well as the impression made during the formal process for evaluating job applicants. This process takes into account the applicant's personal interview. In addition, all applicants are given a skills-based exam to determine not business majors but might be otherwise qualified for a position, the exam also covers some basic business concepts in accounting, finance, and marketing. You have been asked to evaluate the information on the candidates being considered. Fach job application provides the following information: pe proficiency in spreadsheet and database applications. Because some applicants are . College GPA (valid scores range from 1.5 to 4.0) Major Code, universal standardized system that indicates the applicant's undergraduate major; for example, Engineering=1, Business=2, Economics=3, Physical Science=4, and so on (valid codes for majors are 1 through 100) The total number of references submitted by the applicant A Personal Interview Rating If the applicant has previous work experience (TRUE or FALSE) Chapter 4 Applying Logic in Decision Making The undergraduate school ranking (compared with all colleges across the country) The Employment Exam score (valid scores are between 300 and 800) disqualified or automatically hired, or if no decision is made. The criteria, which are The HR manager has established criteria to determine if an applicant will be automatically applied in order, are described in the following list. An applicant is attomatically disqualified if any of the following criteria are TRUE: The applicant has submitted an invalid GPA score, Employment Exam score, or Major Code The applicant has a GPA less than 3.0. The applicant provided fewer than two references. The applicant has an Employment Exam score below 600. The applicant has a Personal Interview Rating of less than 3. An applicant is automatically hired if all of the following criteria are TRUE: The applicant has not been automatically disqualified. The applicant has a GPA score over 3.8. The applicant has a Major Code between 1 and 25 (inclusive). The applicant graduated from one of the top 50 schools (ranking of 50 or less). The applicant has an Employment Exam score above 720. The applicant has a personal interview rating of 4 or higher. The applicant has prior work experience. If an applicant is neither automatically disqualified nor automatically hired, the applicant's Complete the following: 1. Open the workbook named Hiring.xlsx located in the Chapter 4 folder, and then save the file as WWC Hiring Analysis.xlsx 2. Write a formula in cell 14 that can be copied down the column to determine if (TRUE or FALSE) any of the following scores or codes listed for this applicant are invalid: GPA, Major Code, Employment Exam. (Hint: Use the information provided in the problem description to determine the appropriate criteria.) 3. Write a formula in cell J4 that can be copied down the column to determine if (TRUE or FALSE) the applicant should be automatically disqualified based on the gaven criteria. 4. Write a formula in cell K4 that can be copied down the column to determine if this candidate is not automatically disqualified. (Hint: Use the results determined in Step 3.) a Applying Logic in Decision Making 5. In cell 14, write a formula that can be copied down the column to determine if (TRUE or FALSE) the candidate should be automatically hired based on the given criteria . (Hint: For criteria between two values, test that the value is both >= the lower limit and = the lower limit and