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) Delete Paste Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select Analyze Date Sensitivity 47 OA Morge & Center 1 x fc =COUNTIFS/B2:123,">650",C2:C23,"Finance")+COUNTIFS(B2:B23,026+'Question 6-7'!$650",C2;pC23,"Marketing" SUM B C 0 E F G H j K K L M N P R S T U V W X Y 1 2 3 4 4 5 5 . 7 Applicant Origin Department 1 Domestic Finance 9 2 Internations Marketing 10 3 Damestic Finance 11 4 Internation Marketine 12 International Finance 13 Interations Marketing 14 7 Interations Finance 15 Interations Marketing 15 9 International Finance 17 10 International Marketing 1R 11 International Finance 19 12 Damestic Marketing 20 13 Domestic Finance 21 14 Domestic Marketing 22 15 Domestit Finance 23 16 Domestic Marketing 24 17 International Finance 25 18 Damestie Marketing 25 19 Damestic Finance 27 29 29 30 31 32 33 34 35 35 37 IGPA S S IS $ S S IS S S S $ $ $ S S S S $ $ $ $ GMAT Score Industry experience 75 S 567 4 *** 85S 553 10 90S 6415 10 95 S 741 9 92 $ 620 2 87 $ GOT 2 77 $ 6:9 7 80E $ 720 8 97 S 666 2 859 621 a 90$ 691 61 90$ 628 5 85 700 2 37 S 723 4 95 S 627 4 77S 655 10 83$ 631 5 SR $ 670 & 89 $ 590 4 91 $ 589 7 20 Damestic Marketing