ITPEC IP April 2018 Question 22
ITPEC IP April 2018 — Question 22 of 100
The probability row must remain fixed while each product's sales row changes. The required formula is B$2*B4+C$2*C4+D$2*D4. Copying E4 downward keeps row 2 for the weather probabilities but changes row 4 to rows 5 and 6 for Products B and C.
Answer (b)
Why not others:
- option (a) lets the probability references shift downward
- option (c) fixes the product row and uses unsuitable mixed references
- option (d) fixes both probability and product rows, so every copied formula would continue using Product A
Key rule: A dollar sign before the row number locks the row while allowing the column to remain relative.
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.