Question: B E School Sufficient Extracurricular Accept or International Names Grade () Grades? score (%) Reject Student? 2 Long Kuo 84 Yes 3 Maurice Goldenberg 89

B E School Sufficient Extracurricular Accept or
B E School Sufficient Extracurricular Accept or International Names Grade () Grades? score (%) Reject Student? 2 Long Kuo 84 Yes 3 Maurice Goldenberg 89 70 No 4 ZINIu 70 79 No 5 Wei Sundale 73 841 No 6 Li Wei Yang 93 82 Yes 7 Inda Martinez 86 89 No 8 Barbara Uribe 91 71 Yes 9 Sunny Tsui 90 74 No 10 Shen Wei 76 79 No 11 Ho Ko 91 75 No 12 David Thornton 77 85 Yes 13 Maria Cummings 70 81 Yes 14 Dora Armour 83 88 Yes 15 Ruth Arana 94 88 No 16 Balduino Echevarria 94 81 No 17 James Ming 97 77 Yes 18 Mark Raff 70 73 Yes This year, there is more competition and therefore the selection committee has included an extracurricular score. The criteria they have created is that a student will only be accepted if their school grade plus their extracurricular score is higher than 170. They want to use excel to determine who will accept or reject. What is the correct formula that could be entered in cell E2? O =IF(B2+D2170,"accept"reject") O =IF(B2+D2>=170,"accept"reject")

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!