ITPEC IP April 2022 Question 17
ITPEC IP April 2022 — Question 17 of 100
The correct formula is option (b). Its formula is =B$2*B4+C$2*C4+D$2*D4. The probabilities for each weather condition are always in row 2, so their row references must be absolute: B$2, C$2, and D$2. The sales figures must move from row 4 to row 5 and row 6 when the formula is copied downward, so those row references remain relative. The columns should not be fixed because each term must continue pairing the corresponding probability and sales column.
Answer (b)
Why not others:
- formulas without $ on row 2 shift the probability cells downward when copied
- fixing row 4 prevents the sales references from changing for the other products
- fixing the columns is unnecessary and does not solve the required row behavior
Key rule: In a spreadsheet reference, $ before the row number locks the row while leaving the column 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.