ITPEC IP April 2018 Question 20
ITPEC IP April 2018 — Question 20 of 100
Cell I3 should add the previous month's year-to-date total to the first February attendance count. The required formula is D8 + G3. When the February table is copied five columns right for March, the references become I8 + L3, correctly combining February's final cumulative total with March's first session.
Answer (c)
Why not others:
- C8 + D8 combines two January totals and omits February attendance
- C8 + H3 uses January's month total rather than its year-to-date total
- D8 + G8 + H3 includes unrelated cells and does not represent the first-session cumulative calculation
Key rule: Use relative references whose column offsets preserve the same roles when an entire monthly table is copied horizontally.
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.