IPA IP 2023 Question 75
A question IPA Japan published in 令和5年度 ITパスポート試験 公開問題 問75, translated into English. ITPEC is based on the same exams.
Same question on ITPEC: Oct 2024 Q17
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 the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.