ITPEC IP April 2024 Question 20
ITPEC IP April 2024 — Question 20 of 100
The correct formula tests the current branch cell against the monthly average and fixes only the average's columns: IF(C2 < AVERAGE($C2:$E2), 'X', 'O'). If the branch value is below the average, the true result is X; otherwise the false result is O.
When copied horizontally, C2 must change to D2 and E2, so it needs no dollar sign. The average must always span columns C through E, so its column references are absolute: $C and $E. Row 2 must change to rows 4 and 6 when copied to later months, so the row numbers remain relative.
Answer (d)
Why not others:
- (a) and (b) fix the tested value's column and allow the average range to slide horizontally
- (a) and (c) also reverse the required X and O results
- (c) has the right reference pattern but the wrong displayed symbols
Key rule: $ before a column fixes that column during copying; leaving the row relative lets the formula adapt to each month's source row.
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.