ITPEC IP October 2018 Question 18
ITPEC IP October 2018 — Question 18 of 100
Option (d) implements all four grade intervals with the correct boundaries. It assigns Excellent when B1>=10, Good when B1>=0, Not passed when B1<-10, and Passed otherwise. The final otherwise interval is therefore from -10 through values below 0.
Answer (d)
Why not others:
- option (a) assigns the wrong labels to the intervals
- option (b) uses strict comparisons and reverses the lower two outcomes
- option (c) classifies exactly 0 and exactly -10 incorrectly
Key rule: In nested IF expressions, test ranges in order and check boundary values explicitly, because each later branch receives only values rejected earlier.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
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.