Assignment 2 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