ITPEC IP October 2022 Question 22
ITPEC IP October 2022 — Question 22 of 100
The correct formula is option (d). It is IF(C2<AVERAGE($C2:$E2),'X','O'). The evaluated sales cell must move across columns and down rows, so C2 is fully relative. The monthly average must always cover columns C through E, so those columns are fixed with dollar signs, while row 2 remains relative so it changes to rows 4 and 6. The IF results also correctly return X when below average and O otherwise.
Answer (d)
Why not others:
- (a) and (b) fix the evaluated sales column at C
- (a) and (c) reverse the required X and O results
- (c) also allows the average range columns to shift
Key rule: Use mixed references when copying: fix the dimensions that must stay constant and leave changing rows or columns relative.
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.