UGC NET ICT Q34

Question

In the context of MS-EXCEL spreadsheet software, consider a case where there are 10000 random numbers from 0 to 1, located in cells through A10000. How many of the following statements A-D are true?
A. A COUNTIFS function in cell B2 with one criteria, based on the range A1:A10000, cannot evaluate to less than 0
B. A COUNTIFS function in cell B2 with two criteria, each based on the range A1:A10000, cannot evaluate to less than 0
C. A COUNTIFS function in cell B2 with one criteria, based on the range A1:A10000, cannot evaluate to greater than 10000
D. A COUNTIFS function in cell B2 with two criteria, based on the range A1:A10000, cannot evaluate to greater than 10000
Choose the correct answer from the options given below:

Accepted Answer

4