The table in the figure shows final student evaluations for a course in Computer Science. What is the correct IF-statement you would write in cell K6, and eventually drag to cell K16, to determine if the student has passed or failed the course? Refer to the accompanying grade guide and the final marks in column J. Choose as many answers as you think are correct. B DE F G H 1 J K 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 19 20 21 22 23 24 25 26 Martin Riggs Frank Poole Dave Bowman Charles F. Kane Ellie Arroway Emma Molley Mike Oldhouse Anton McVille Meg Altman Erin Bronston Lena Power 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 15.0 39.5 85.0 49.0 100.0 98.3 100.0 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.51 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 98.9 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 Final Mark Passed?* 100% 64.2 YES 74.5 YES 68.3 YES 49.5 NO 72.1 YES 65.7 YES 60.2 NO 87.6 YES 70.2 YES 74.4 YES 66.6 YES FAIL "Grade guide: %-age Grade 0 F 50 D 63 75 B 96 A+ PASS 87 OA. =IF(VLOOKUP(JG, SI$21:$J$26, 2)123,"YES","NO") C. =IF(OR(VLOOKUP(J6, $1$21:$J$26, 2)="D", VLOOKUP(J6, $1$21:$J$26, 2)="F"), "NO", "YES") OD. FIF(J6>=$1$23,"YES","NO") E. IF(J6>=123,"YES","NO") F. =IF(OR(VLOOKUP(J6, $1$21:$J$26, 2)="F", VLOOKUP(J6, $I$21:$J$26, 2)="D"), "YES", "NO") G. =IF(OR(VLOOKUP(J6, $I$21:$J$26, 2)="F", VLOOKUP(J6, $1$21:$J$26,2)="D"), "NO", "YES")