ITPEC IP October 2025 Question 21
ITPEC IP October 2025 — Question 21 of 100
Lock probability row 2 but let each product row change — B$2*B4+C$2*C4+D$2*D4 has the required mixed references.
When copied downward, B4, C4, and D4 must become row 5 and then row 6 so each product uses its own sales estimates. The weather probabilities must remain in row 2, so $ fixes only their row numbers. Columns stay unchanged because copying is vertical.
Answer (b)
Why not others:
- (a) lets probability references move to rows 3 and 4
- (c) fixes product row 4, so every copied formula still uses Product A
- (d) fixes both probabilities and product estimates completely
Key rule: In a copied formula, place $ only before the coordinate that must remain fixed.
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.