hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    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
    368k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow