ITPEC IP April 2019 Question 20
ITPEC IP April 2019 — Question 20 of 100
The formula must fix the principal completely, let the interest-rate column change, and let the year row change. $B$1 always refers to the principal. B$2 fixes row 2 while allowing B to become C through F when copied right. $A4 fixes column A while allowing the row to become 5 through 13 when copied down. Thus the formula is $B$1*((1+B$2)^$A4-1).
Answer (c)
Why not others:
- (a) fixes the interest-rate column, so every result uses B2
- (b) also fixes the interest-rate column and lets the year column move
- (d) lets the year column move right instead of keeping it at A
Key rule: In a spreadsheet reference, $ fixes the coordinate immediately following it; mixed references lock only the row or only the column.
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.