Using excel please solve the following table (Hint: use if function) Students MATH102 CHM110 HARRY 96 87 OLIVER 23 46 JACK 0 66 ALFIE 4 49 CHARLIE 58 58 THOMAS 34 JACOB 10 96 Find the requirements: A. In a column beside CHM110, write a function for each student to check if the student passed the two given courses (passing grade >=50) (use "PASS" or "FAIL" for the outcome) B. In a column beside requirement A, write a function to find average for the students who passed the two courses and to write "Must Take Re-sit" for the student who failed