ITPEC IP October 2024 Question 92
When the spreadsheet shown below is converted into CSV format, which of the following is an appropriate list of data that is generated by spreadsheet software? Here, records are separated by the carriage return code “CR”. The expression in a cell is automatically recalculated, and the resulting value is written back into that cell. Although the entered expressions are shown in row 3 and column C below, the resulting values are actually displayed on the screen.
Explanation
2,7,6 / 6,4,13 / 8,11,24 — evaluate every expression, then write the values row by row.
The expressions evaluate to:
- •C1 = A1 + B2 = 2 + 4 = 6
- •C2 = A2 + B1 = 6 + 7 = 13
- •A3 = A1 + A2 = 2 + 6 = 8
- •B3 = B1 + B2 = 7 + 4 = 11
- •C3 = C2 + B3 = 13 + 11 = 24
CSV writes one record per row, with the fields from column A to column C separated by commas and each record ended by the carriage return: 2,, 6,, 8,.
Answer (c)
Why not others:
- •(a) — has the correct values but writes them column by column (A, then B, then C) instead of row by row
- •(b) — also column by column, and takes each C value as the plain row sum, 9, 10 and 19, instead of following the cross-referencing expressions
- •(d) — the row order is right, but C1, C2 and C3 are the row sums 9, 10 and 19 rather than A1+B2, A2+B1 and C2+B3
Key rule: CSV stores the calculated values, not the expressions, as one record per row with the fields in column order.
Software · AI-written, may contain errors
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.