ITPEC IP October 2024 Question 92
ITPEC IP October 2024 — Question 92 of 100
The generated CSV contains the evaluated cell values in row order. Its rows are 2,7,6, 6,4,13, and 8,11,24. The formula results are C1 = A1+B2 = 2+4 = 6, C2 = A2+B1 = 6+7 = 13, A3 = A1+A2 = 8, and B3 = B1+B2 = 11. Finally C3 = C2+B3 = 13+11 = 24. CSV separates fields with commas and records with the stated carriage return.
Answer (c)
Why not others:
- (a) and (b) place values in column order rather than row order
- (d) uses incorrect C1, C2, and C3 results
Key rule: First evaluate every dependent formula, then serialize left-to-right across each row and top-to-bottom across rows.
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.