In an MS-Excel spreadsheet, column B holds the customer category (for example Child or Adult). Given below are two statements about counting adults. In the light of the above statements, choose the most appropriate answer from the options given below.
Statement I:The formula = COUNTIFS(B2:B101, "Adult") counts all customers who are adults.
Statement II:The formula = COUNTIFS(B2:B101, "=Adult") counts all customers who are adults.
ABoth Statement I and Statement II are correct ✓ Correct
BBoth Statement I and Statement II are incorrect
CStatement I is correct but Statement II is incorrect
DStatement I is incorrect but Statement II is correct
Correct answer: (A) Both Statement I and Statement II are correct
Explanation
Statement 1 is correct because COUNTIFS with the plain Adult criterion counts every cell equal to Adult.
Statement 2 is correct too, since the equals Adult form is just an explicit way of writing the same equality test.
Both forms treat the text as an exact match and return the same count.
The equals sign inside the quotes may be left out and does not change the result.
COUNTIFS tallies cells across a range that meet the given condition.
Text criteria in COUNTIFS are not case sensitive by default.
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 →