6&7 go together please

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) 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. (10 points) C Department Finance 1 Domestic 2 Internationa Marketing 3 Domestic Finance 4 Internationa Marketing 5 Internationa Finance 6 Internation Marketing 7 Internationa Finance 8 Internationa Marketing 9 Internationa Finance 10 Internationa Marketing 11 International Finance 12 Domestic Marketing Finance 13 Domestic 14 Domestic Marketing 15 Domestic Finance 16 Domestic Marketing 17 Internationa Finance 18 Domestic Marketing 19 Domestic Finance S 20 Domestic Marketing A B 1 Applicant Origin 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 GPA GSSseses ess $ $ $ $ $ $ $ $ $ $ $ in es estes $ SSSSSSSS $ $ $ $ $ $ D 10 E F GMAT score Industry experience 567 4 553 645 741 680 607 619 720 666 611 691 628 700 723 627 655 631 670 590 589 75 $ 85 $ 90 $ 95 $ 92 $ 87 $ 77 $ 80 $ 97 $ 85 $ 90 $ 90 $ 86 $ 87 $ 96 $ 77 $ 83 $ 88 $ 89 $ 91 $ 10 10 8 2 4 6 5 2 4 10 5 8 47