ITPEC IP October 2018 Question 17
ITPEC IP October 2018 — Question 17 of 100
The formula needs a relative score reference and a row-fixed perfect-score reference. The required expression is 100*B3/B$2. B3 must change by both row and column so each copied cell uses the corresponding student's subject score. The perfect score must change from B to C to D when copied horizontally, but its row must remain fixed at row 2.
Answer (b)
Why not others:
- $B2 fixes the subject column and lets the perfect-score row move
- $B3/$B2 fixes both references to the English column
- B$3/B$2 fixes the student's row and would not move down for other students
Key rule: A dollar sign before the row fixes the row; a dollar sign before the column fixes the column during formula 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.