ITPEC IP April 2020 Question 18
ITPEC IP April 2020 — Question 18 of 100
The formula must compare the current branch value with the row average while fixing average columns C through E. Option (d) uses C2 as the value being evaluated, $C2:$E2 as the monthly range, and returns X when below average and O otherwise.
Answer (d)
Why not others:
- fixing C in the compared value prevents it from shifting to branches B and C
- leaving the average columns relative makes the three-branch range drift when copied horizontally
- reversing O and X contradicts the stated evaluation rule
Key rule: Mixed references lock the columns of the comparison range while allowing its row to change for each month.
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.