Question 6) using an advanced filter, 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.

Question 7) after applying the advanced filter in Question 6, write a function in cell K3 to return Yes if the Average GMAT score of applicants in the filtered table is greater than 650, otherwise cell K3 should be left blank.

Excel par:2 Assiqnmen Ece Dalo Ravic View HeloTelme whut you wan to do % 1w in Formula Wilch Caluinalculare Sheet Functian bar Origin epertment GPA GMAT S Industry experieme Applant Origin Departmen GPA GM41soo Industry experiece 4 | Internation Mdrsetn Internation Marketina Ovesticn 1 Question G-7estin O lype hene to search