Your parents allow you to go on a trip if you meet the final-exam-score condition, or meet both the homework and midterm conditions. In the spreadsheet, column B holds the minimum required results and column C the actual results, with rows 2, 3 and 4 being homework hours, midterm score and final exam score. Which of the following formulas can be used in cell D2 to decide whether you can join your friends?
1.=IF(C4>=B4, "Yes", IF(AND(C2>=B2, C3>=B3), "Yes", "No"))
2.=IF(AND(C2>=B2, C3>=B3), "Yes", IF(C4>=B4, "Yes", "No"))
3.=IF(OR(AND(C2>=B2, C3>=B3), C4>=B4), "Yes", "No")
A1 & 2 only
B1 & 3 only
C2 & 3 only
D1, 2 & 3 ✓ Correct
Correct answer: (D) 1, 2 & 3
Explanation
The rule passes a student when the final exam meets its minimum, or when both homework and midterm meet theirs.
The first formula returns Yes on a good final, otherwise checks that both homework and midterm pass together.
The second formula first checks the homework-and-midterm pair, then falls back to the final exam.
The third formula joins the same tests with OR around an AND, in a single condition.
All three express the identical logic and reach the same Yes or No result.
OR needs just one branch true, while the AND inside it demands both of its own tests pass.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →