ITPEC IP April 2018 Question 91
ITPEC IP April 2018 — Question 91 of 100
The calculated CSV data matches option (c). The rows are 2,7,6, 6,4,13, and 8,11,24. C1 is A1+B2 = 2+4 = 6; C2 is A2+B1 = 6+7 = 13; A3 is 8 and B3 is 11; therefore C3 is C2+B3 = 13+11 = 24.
Answer (c)
Why not others:
- options (a) and (b) transpose or misorder the worksheet's row and column data
- option (d) uses within-row sums for C1 and C2 instead of their actual cross-row formulas
Key rule: CSV exports displayed cell values row by row; it does not preserve spreadsheet formulas or cell formatting.
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.