ITPEC IP April 2025 Question 20
ITPEC IP April 2025 — Question 20 of 100
2 — the copied formula counts Product C's monthly values that are strictly greater than 15,000.
When the formula is copied from E2 to E4, the relative range B2:D2 moves to B4:D4. Product C has 10,000, 20,000, and 30,000. The criterion >15000 is satisfied by 20,000 and 30,000, so COUNTIF returns 2.
Answer (c)
Why not others:
- (a) 0 ignores the two qualifying values
- (b) 1 counts only one of 20,000 and 30,000
- (d) 3 incorrectly includes 10,000; it is below the threshold
Key rule: Relative references shift when copied, and COUNTIF counts cells that satisfy the stated criterion; > excludes values equal to or below the threshold.
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.