ITPEC IP October 2023 Question 21
ITPEC IP October 2023 — Question 21 of 100
Cell E4 displays 2 because two values in B4:D4 are greater than 15,000. When the formula is copied from E2 down to E4, the relative range B2:D2 becomes B4:D4. Product C has monthly sales of 10,000, 20,000, and 30,000. Only 20,000 and 30,000 satisfy the criterion >15000; 10,000 does not.
Answer (c)
Why not others:
- 0 would mean none of the three values passed the condition
- 1 overlooks one of the two qualifying months
- 3 incorrectly includes 10,000
Also note that a value exactly equal to 15,000 would not be counted because the operator is strictly greater than, not greater than or equal to.
Key rule: Copied relative cell references shift with the destination row, and COUNTIF counts only cells satisfying its stated criterion.
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.