undefined

You need to create a final letter grade based on the final mark in column J. What is the correct function to do this? Create the function in Ko and create it so it can be correctly copied down to K16. D E F 1 A B H 1 J CSC 105, Spring 2013 - Introduction to Information Technology Student 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Exam 1 Exam 2 Exam 3 Assignments Labs Attend. 20% 20% 20% 20% 15% 5% 51.0 45.0 48.0 99.5 98.3 20.0 39.5 85.0 49.0 100.0 98.3 100.00 59.0 63.5 37.0 99.0 77.2 100.0 59.0 41.9 15.0 49.5 96.4 40.0 70.0 73.0 35.0 100.0 96.4 40.0 29.0 53.5 47.0 100.0 98.9 100.0 23.0 51.0 28.0 100.0 98.9 100.0 52.0 100.0 87.0 100.0 100.0 40.0 60.0 68.0 100.0 77.2 100.0 56.0 70.0 47.0 100.0 98.9 100.00 55.0 60.0 75.0 50.0 90.9 100.0 Martin Riggs Frank Poole Dave Bowman Charles F. Kane Ellie Arroway Emma Molley Mike Oldhouse Anton McVille Meg Altman Erin Bronston Lena Power Final Mark 100% 64.5 74.5 68.3 49.5 72.1 65.7 60.2 87.6 70.2 74.4 66.6 Letter Grade F 98.91 D 19 FAIL 20 21 22 23 24 25 26 *Letter grade guide: %-age Grade 0 F 50 63 75 B. 87 A 96 A+ PASS Select all that are correct. OOOO OA. =vlookup($J$6, SI$21:$J$26, 2) OB. Evlookup(J6, $1$21:$J$26, 2) C. =vlookup(J6, $I$21:$K$26, 2) D. =vlookup(J6, $121:$J26, 2)