ITPEC IP April 2021 Question 86
ITPEC IP April 2021 — Question 86 of 100
After formula evaluation, the CSV rows are 2,7,6; 6,4,13; and 8,11,24. C1 is A1 + B2 = 2 + 4 = 6, and C2 is A2 + B1 = 6 + 7 = 13. Then A3 = 2 + 6 = 8, B3 = 7 + 4 = 11, and C3 = C2 + B3 = 13 + 11 = 24.
Answer (c)
Why not others:
- the alternatives either transpose rows and columns or use incorrect formula results
- CSV stores the displayed calculated values here, not the formula text
Key rule: Recalculate dependent cells first, then export values in row order with commas between fields and record separators between 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.