1. Please insert a VLOOKUP function in cell M14 to find the students classification based on the lookup table in J4:L9. Copy the function to Column M.

2. Enter a nested lookup function in cell H9 to identify the last name of the person who had the highest overall score for all applications

19 xv fx A ABC University Admissions Office Applications for Fall 2020 Admission WN Student Classification In State Out State Admission Criteria Standard Early Reject Early Admit 5 SAT 1100 2200 6 GPA 1.75 3.75 2500 3000 3500 4000 Miscellaneous Standards & Filter Initial Deadline 3/15/18 A A 10 Threshold Score 2800 Person w Highest Score Average SAT of early admitted students Days Before Deadline First SAT Admit Early Reject Early Final Decision Email Address St 13 Last 14 Aaron 15 Abrell 16 Adili 17 Alevy 18 Algeo 19 Altman 20 Ancona 21 Anderson 22 Andrade 23 Applegate 24 Armstrong 25 Arnold 26 Augustine 27 Austin 28 Axelrod 29 Bagley 30 Bak 31 Balmer 32 Barker Frank Sharon Diane Julie George Samuel Jacqueline Leigh Ellen Jennifer Elizabeth Monica Bill Alissa Brian Ken Read Hannah Shelly Residence In State Out State In State Out State In State Out State Out State In State Out State In State In State Out State Out State Out State In State Out State Out State In State Out State Date Received 2/14/18 12/29/17 4/14/18 11/15/17 2/15/18 3/1/18 2/28/18 1/15/18 12/15/17 12/14/17 2/14/18 2/1/18 12/1/17 11/30/17 2/24/18 2/2/18 1/15/18 11/25/17 12/15/17 1306 2350 1000 2290 750 1150 1200 1000 1134 2000 2200 100D 1200 1100 1825 998 1574 1351 950 GPA 3.65 3.00 2.29 4.00 2.60 2.29 3.35 2.84 2.25 3.83 3.50 2.35 2.93 4.00 3.52 3.08 3.18 3.38 2.87 Score 3496 4150 2374 4690 2310 2524 3210 2704 2484 4298 4300 2410 2958 3500 3937 2846 3482 3379 2672