In an MS Excel spreadsheet of 100 customers, column C is the payment category, where 0 means discounted price and 1 means full price. In the light of the above statements, choose the correct answer from the options given below.
Statement I:The formula =COUNTIFS(C2:C101, "0") counts all customers who get a discounted price.
Statement II:The formula =COUNTIF(C2:C101, "=0") counts all customers who get a discounted price.
ABoth Statement I and Statement II are true ✓ Correct
BBoth Statement I and Statement II are false
CStatement I is true but Statement II is false
DStatement I is false but Statement II is true
Correct answer: (A) Both Statement I and Statement II are true
Explanation
Writing =COUNTIFS(C2:C101, 0) counts the cells in that range holding the value 0, the discounted customers.
Writing =COUNTIF(C2:C101, =0) likewise counts the cells equal to 0 across the same range.
Both forms therefore return the same tally of customers who received the discounted price.
COUNTIFS accepts one or more conditions, so a single condition works within it.
COUNTIF is the single-condition version and treats =0 as a match on the value zero.
The discount code 0 separates discounted customers from full-price ones coded as 1.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Practise on Mcqkart →🎓 Book an expert →