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) Question 8) use a pivot table to show the average GPA and the average GMAT score of all the applicants based on their origin and their department. (10 points) b 10 7 Applicant Origin Department 8 1 Domestic Finance 9 2 Internations Marketing 10 3 Domestic Finance 11 4 Internations Marketing 12 5 Internation Finance 13 6 Internation Marketing 14 7 Internationa Finance 15 8 Internation Marketing 16 9 Internation Finance 17 10 Internation Marketing 18 11 Internation Finance 19 12 Domestic Marketing 20 13 Domestic Finance 21 14 Domestic Marketing 22 15 Domestic Finance 23 16 Domestic Marketing 24 17 Internation Finance 25 18 Domestic Marketing 26 19 Domestic Finance 27 20 Domestic Marketing 28 GPA $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ GMAT score Industry experience 75 $ 567 4 85$ 553 90 $ 645 10 95$ 741 9 92 $ 680 2 87$ 607 2 77 $ 619 7 80 $ 720 8 97 S 666 2 85$ 611 4 90S 691 6 90 S 628 5 86 $ 700 2 87$ 723 4 96 S 627 4 77 $ 655 10 83 $ 631 5 88 $ 670 8 89 $ 590 4 91 $ 589 7 20 D E A B E F 1 Applicant Origin Department GPA GMAT score Industry experience 2 1 Domestic Finance $ 75 $ 567 4 3 2 International Marketing $ 85 $ 553 10 4 3 Domestic Finance $ 90$ 645 10 5 4 International Marketing $ 95 $ 741 9 6 5 International Finance $ 92 $ 680 2 7 6 International Marketing $ 87$ 607 2 8 7 International Finance $ 77 $ 619 7 9 8 International Marketing $ 80 $ 720 8 10 9 International Finance $ 97 $ 666 2 11 10 International Marketing $ 85 $ 611 4 12 11 International Finance $ 90 $ 691 6 13 12 Domestic Marketing $ 90 S 628 5 14 13 Domestic Finance $ 86 $ 700 15 14 Domestic Marketing $ 87$ 723 4 16 15 Domestic Finance $ 96 $ 627 4 17 16 Domestic Marketing $ 77 $ 655 10 18 17 International Finance $ 83S 631 5 19 18 Domestic Marketing $ 88$ 670 8 20 19 Domestic Finance $ 89 $ 590 4 21 20 Domestic Marketing $ 91S 589 7 22 23 24 25 26 27 Question 1-5 Question 6-7 Question 8 2. $