Question: Question 3 ) write a Hlookup function in Cell H 2 to assign the appropriate school - based financial aid to the applicants based on

Question 3) write a Hlookup function in Cell H2 to assign the appropriate school-based financial aid to the applicants based on their GPA. (10 points)
Question 4) write a function in cell N22 to compare the average GPA of domestic and international applicants. If the GPA of the domestic applicants is greater than the international applicants, the function should return domestic otherwise it should be international. (10 points)
Question 5) In addition to the school-based financial aid, the Department of finance and Marketing has an extra budget to offer financial aid to the students based on their GMAT scores. Write a function in cell 12 that returns "not qualified" if the GMAT score of the applicants is below 600 or they are from the Information Systems department. Otherwise, the function should assign the appropriate scholarship to the applicants of each department based on the GMAT score. (20 points)
 Question 3) write a Hlookup function in Cell H2 to assign

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!