Question 3) write a Hlookup function in Cell H2 to assign the appropriate school based-financial aie he applicants based on their GPA. (10 points) 5 Sater to stay in Protected View. Question 3) write a Hlookup function in Cell H2 to assign the appropriate school based-tinancia the applicants based on their GPA. (10 points) Question 4) write a function in cell N22 to compare the average GPA of domestic and internatic applicants. If the GPA of the domestic applicants is greater than the international applicants, th function should return domestic otherwise it should international. (10 points) Question 5) In addition to the school-based financial aid, the department of finance and market their own extra budget to offer financial aid to the students based on their GMAT score. Write a function in cell 12 that returns "not qualified" if the GMAT score of the applicants is below 600 om are from Information Systems department. Otherwise, the function should assign the appropriat scholarship to the applicants of each department based on the GMAT score. (20 points) Question 6) Use an advanced filter to filter the table in a way that it only shows the domestic app in the Department of Finance with GPA greater than 80 and GMAT score greater than 600. (10 po Question 7) after applying the advanced filter in Question 6, write a function in cell K3 to return the Average GMAT score of applicants in the filtered table is greater than 650, otherwise cell K3 st be left blank. (10 points) Question 8) use a pivot table to show the average GPA and the average GMAT score of all the applicants based on their origin and their department. (10 points) Question 3) write a Hlookup function in Cell H2 to assign the appropriate school based-financial aie he applicants based on their GPA. (10 points) 5 Sater to stay in Protected View. Question 3) write a Hlookup function in Cell H2 to assign the appropriate school based-tinancia the applicants based on their GPA. (10 points) Question 4) write a function in cell N22 to compare the average GPA of domestic and internatic applicants. If the GPA of the domestic applicants is greater than the international applicants, th function should return domestic otherwise it should international. (10 points) Question 5) In addition to the school-based financial aid, the department of finance and market their own extra budget to offer financial aid to the students based on their GMAT score. Write a function in cell 12 that returns "not qualified" if the GMAT score of the applicants is below 600 om are from Information Systems department. Otherwise, the function should assign the appropriat scholarship to the applicants of each department based on the GMAT score. (20 points) Question 6) Use an advanced filter to filter the table in a way that it only shows the domestic app in the Department of Finance with GPA greater than 80 and GMAT score greater than 600. (10 po Question 7) after applying the advanced filter in Question 6, write a function in cell K3 to return the Average GMAT score of applicants in the filtered table is greater than 650, otherwise cell K3 st be left blank. (10 points) Question 8) use a pivot table to show the average GPA and the average GMAT score of all the applicants based on their origin and their department. (10 points)