arrow
arrow
arrow
In the context of MS-EXCEL spreadsheet software, consider a case where there are 1000 random numbers from 0 to 1, located in cells Al through A10000.
Question

In the context of MS-EXCEL spreadsheet software, consider a case where there are 1000 random numbers from 0 to 1, located in cells Al 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 Al:A10000, cannot evaluate to less than 0
B. A COUNTIFS function in cell B2 with one criteria, each based on the rang Al A10000, cannot evaluate to less than 0
C. A COUNTIFS function in cell B2 with one criteria, based on the range Al:A10000, cannot evaluate to greater than 10000
D. A COUNTIFS function in cell B2 with one criteria, based on the range Al:A10000, cannot evaluate to greater than 10000
Choose the correct answer from the options given below:

A.

4

B.

3

C.

2

D.

1

Correct option is A

Free Tests

Free
Must Attempt

Basics of Education: Pedagogy, Andragogy, and Hutagogy

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

UGC NET Paper 1 Mock Test 1

languageIcon English
  • pdpQsnIcon50 Questions
  • pdpsheetsIcon100 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Basics of Education: Pedagogy, Andragogy, and Hutagogy

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon12 Mins
languageIcon English
test-prime-package

Access ‘UGC NET December’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow