ITPEC IP October 2020 Question 18
ITPEC IP October 2020 — Question 18 of 100
The correct choice fixes the probability row and leaves each product's sales row relative. The formula is B$2×B4+C$2×C4+D$2×D4. The weather probabilities must always come from row 2 when copied downward, while the sales references must change from row 4 to rows 5 and 6.
Answer (b)
Why not others:
- (a) lets the probability row shift when copied
- (c) incorrectly locks sales row 4 and shifts the probability columns
- (d) locks all references, producing the same Product A calculation in every row
Key rule: $ before a row fixes the row; $ before a column fixes the column during copying.
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.