Question 3) write a Hlookup function in Cell H2 to assign the appropriate school based-financial aid to the applicants based on their GPA. (hlook table 1)

Question 4) In addition to the school-based financial aid, the department of finance and marketing have their own extra budget to offer financial aid to the students based on their GMAT score. Write a function in cell I2 that returns not qualified if the GMAT score of the applicants is below 600 or they are from Information Systems department, otherwise, the function should assign the appropriate scholarship to the applicants of each department based on the GMAT score.

Excel par:2 Assiqnmen Ece Dalo Ravic View HeloTelme whut you wan to do % 1w in Formula Used Functian bar Defined Haries Years uf ndustry Applicant id pvel School Dcmastic Infermaticn Systems AN A Markeli Markatin Markat Markeli ery Hi Hlackup2 Intem:tion Infcrmaticn Systems Markat Dcmastic Infermaticn Systems Markeli Mediur Dcmastic Infermaticn Systems ery Hi Markat Dcmastic Infermaticn Systems Markeli Domestic or International Question 1-5 | Ovesticn-7 oestiun U l O lype hene to search