BECE Computing 2026 Paper

Concept:Use the IF function to check each candidate’s score against the pass mark and return “Pass” or “Fail”.Explanation:IF tests a condition and gives different results based on whether the condition is true or false.For example, if a candidate’s score is in cell B2 and the pass mark is 50:$= \text{IF}(B2 \geq 50, \text{“Pass”}, \text{“Fail”})$This determines each candidate who passed. Other functions like COUNTIF only count, not determine individual status.Answer:A. IF