Important notes: . If your function doesn't work, remove the equal sign "=" from your function to receive partial credit. Question 1) answer the following questions by using the conditional statistical functions: (20 points) a. Write a function/formula in cell D24 to calculate the number of applicants who are from the department of finance or the department of marketing b. Write a function/formula in cell E24 that returns the average GPA of applicants who are from the department of finance or the department of marketing. Question 2) write a nested If function in cell G2 to return "low", "Average" or "High" based on the applicants' industry experience. You can find the criteria in the below table. (10 points) industry experience Experience Level Less than 3 years Low greater than or equal 3 and less than 5 years Average Greater than or equal 5 years High 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 international. (10 points) Question 5) 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 12 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 (20 points) Question 6) Use an advanced filter to filter the table in a way that it only shows the domestic applicants in the Department of Finance with GPA greater than 80 and GMAT score greater than 600. (10 points) Trans ORA Epimeda Scheda De 24 3 Man SI DOC face SO SL SEO 5 Applicant Origin Department 1 Domestic Finance 2 internations Marketing 3 Domestic Finance internations Marketing internation Finance internations Marketing 7 internation Finance 8 internation Marketing 9 internation Finance 10 interations Marketing 11 Internation Finance 12 Domestic Marketing 13 Domestic Finance 14 Domestic Marketing 15 Domestic Finance 16 Domestic Marketing 17 Internation Finance 18 Domestic Marketing 19 Domestic Finance 20 Domestic Marketing GPA GMAT score Industry experience S 755 567 5 85S 553 10 S 90 S 645 10 S 95 S 741 S IS 9215 580 S 875 507 S 7715 619 S 805 720 S 97 S 666 s 855 611 S 90 15 6 IS 90S 628 5 IS 85 S 700 2 S 875 723 4 5 965 527 4 S 7715 655 10 S 83 S 691 5 S 8815 670 S 89S 590 S 915 589 691 Applicant Origin Department GPA Domestic Finance $ 2 International Marketing S 9 Domestic Finance $ 4 International Marketing 5 Sinternational Finance $ 6 International Marketing $ 7 International Finance 5 Blinternational Marketing 15 9 international Finance US 10 International Marketing 5 38 International Finance S 12 Domestic Marketing 5 13 Domestic Finance 14 Domestic Marketing 15 19 Domestic Finance 5 16 Domestic Marketing S 17 International Dance S 16 Domestic Marketing 5 19 Domestic Finance S 20 Domestic Marketing 5 GMAT score Industry experience 755 567 4 855 553 10 905 545 10 955 741 925 560 875 607 775 619 805 1973 666 855 631 905 591 9075 625 853 700 675 723 955 627 775 655 20 35 631 03 620 590 913 589 1925