ITPEC IP October 2021 Question 22
ITPEC IP October 2021 — Question 22 of 100
Cell E4 displays 2. Copying the formula from E2 to E4 changes the relative range B2:D2 to B4:D4. Product C's values are 10,000, 20,000, and 30,000; two of them are strictly greater than 15,000, so COUNTIF returns 2.
Answer (c)
Why not others:
- 10,000 does not satisfy the condition
- both 20,000 and 30,000 satisfy it, so the result is neither 0 nor 1
- only three cells are tested and one fails, so the result is not 3
Key rule: Relative cell references shift when copied, and COUNTIF counts only cells that satisfy the specified comparison.
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.