A student is considered for placement on the Dean's List if their final mark in this course is at least A. Referring to the table in the figure, which of the following IF-statements determines whether a student should be considered for placement on the Dean's List? The results are displayed in cells L6 to L16. Choose as many answers as you think are correct. B D E F H . J A CSC 105, Spring 2013 - Introduction to Information Technology 1 2 3 4 5 6 Student Martin Riggs Frank Poole Dave Bowman Charles F. Kane Ellie Arroway Emma Molley Mike Oldhouse Anton McVille Meg Altman Erin Bronston Lena Power 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Exam 1 Exam 2 Exam 3 Assignments Labs Attend. 20% 20% 20% 20% 15% 5% 51.0 45.0 48.0 99.5 98.31 20.01 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.5 47.0 100.0 98.9 100.0 23.0 51.01 28.0 100.0 98.9 100.0 52.0 100.0 100.0 98.9 100.0 40.0 60.0 68,0 100.0 77.21 100.0 56.0 70.0 47.0 100.0 98.9 100.0 55.0 60.01 75.0 50.0 90.91 100.0 Final Mark Passed?* 100% 64.5 YES 74.51 YES 68. YES 49.5 NO 72. YES 65.7 YES 60.2 NO 87.6 YES 70.2 YES 74.4 YES 66.6 YES Consider for Dean's List? NO NO NO NO NO NO NO YES NO NO NO 87.0 FAIL *Letter grade guide: %-age Grade 0 F 50 D 63 75 B 87 A 96 A+ PASS OA. =IF(OR(K6="YES", J6>=$J$25), "YES", "NO") B. =IF(AND(J6>=$J$25, J6>=$J$26), "YES", "NO") O C. EIF(OR(VLOOKUP(J6, $J$21:$K$26,2)="A", VLOOKUP(J6, $J$21:$K$26, 2)="A+"), "YES", "NO") OD. FIF($J$6>=J25,"YES","NO") OE. EIF(OR(AND(J6>=$J$25, J6=$J$26). "YES", "NO") OF. EIF(AND(K6="YES", J6>=$J$25), "YES", "NO") G. =IF(J6>$J$25,"YES", "NO") O H. =IF(J6>=$J$25, "YES", "NO") O l. =IF(J6>=J25,"YES","NO")