ITPEC IP October 2018 Question 20
ITPEC IP October 2018 — Question 20 of 100
The formula needs a fixed price column and a fixed tax-rate row. The expression is $B4*(1.0+D$2). The price always comes from column B, so its column is fixed while its row changes for each product. The tax rate always comes from row 2, so its row is fixed while its column changes from D to E.
Answer (c)
Why not others:
- fully relative references move the tax-rate row when copied downward
- option (b) fixes the price row and allows its column to move
- option (d) fixes both the price cell and tax-rate column, preventing the required changes
Key rule: Use $B4 for a fixed price column with a variable product row, and D$2 for a variable tax column with a fixed rate row.
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.