In the following MS-EXCEL spreadsheet, you are given a list of 100 customers.…

PYQ UGC NET 2023

In the following MS-EXCEL spreadsheet, you are given a list of 100 customers. Column ‘A’ represents their names, ‘B’ is for customer category, ‘C’ for payment category (0 means discounted price and 1 means full price); ‘D’ indicates price that customer pays. The list in the example spreadsheet below is not complete and simply shows different categories. A B C D 1 CustomerName Customer Category Payment Category Price (%) 2 Raman Child 0 0 3 Dinesh Adult 1 5 4 Jashan Adult 0 2 101 Amit Child 0 0 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. In light of the above statements choose the most appropriate answer from the options given below

  1. A.

    Both Statement (I) and Statement (II) are true

  2. B.

    Both Statement (I) and Statement (II) are false

  3. C.

    Statement (I) is true but Statement (II) is false.

  4. D.

    Statement (I) is false but Statement (II) is true.

Attempted by 2 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…