ITPEC IP October 2024 Question 17
It is determined whether an examinee passed or failed by evaluating the score for two (2) subjects X and Y with a spreadsheet software program. The score of each subject is entered in cells A2 and B2 of the worksheet. When passing criteria (1) or (2) is met, “Pass” is displayed in cell C2, and otherwise, “Fail” is displayed. Which of the following is the expression that is entered in cell C2?
Explanation
IF(OR(...), 'Pass', 'Fail') — meeting any one condition is enough, so the conditions are joined with OR and Pass is the value when true.
Criterion (1) is (A2+B2) ≥ 120. Criterion (2), a score of 100 in either subject, is A2 = 100 or B2 = 100. The examinee passes if any of these three conditions holds, which is OR. IF( returns its second argument when the condition is true, so 'Pass' comes second and 'Fail' third.
Check with the figure: 50 + 80 = 130 ≥ 120, so C2 shows Pass.
Answer (c)
Why not others:
- •(a) — AND requires all three at once, including 100 in both subjects, so the 50/80 examinee would get Fail
- •(b) — AND with the results swapped: Fail only for someone meeting every condition, Pass for everyone else
- •(d) — the OR condition is right but the results are swapped, so the 50/80 examinee who meets criterion (1) gets Fail
Key rule: "Any one of" the conditions means OR, "all of" means AND; in IF the result when true is the second argument and the result when false is the third.
Software · AI-written, may contain errors
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.