In MS Excel, consider 10000 random numbers from 0 to 1 located in cells A1 through A10000. Consider these statements: A. A COUNTIFS function with one criterion on the range A1:A10000 cannot evaluate to less than 0. B. A COUNTIFS function with two criteria, each on A1:A10000, cannot evaluate to less than 0. C. A COUNTIFS function with one criterion on A1:A10000 cannot evaluate to greater than 10000. D. A COUNTIFS function with two criteria on A1:A10000 cannot evaluate to greater than 10000. How many of these statements are true?

All four statements are true, so the count of true ones is four.

A COUNTIFS result is a count of matching cells, which can never fall below zero, covering the first two claims.

With one criterion, the count cannot exceed the 10000 cells being tested.

With two criteria on the same range, the count still cannot exceed the 10000 cells available.

Adding conditions only narrows a count, so it can shrink toward zero but never go negative or beyond the total.

COUNTIFS tallies whole cells, so its answer is always a non-negative whole number.