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
- A.
Both Statement (I) and Statement (II) are true
- B.
Both Statement (I) and Statement (II) are false
- C.
Statement (I) is true but Statement (II) is false.
- D.
Statement (I) is false but Statement (II) is true.
Attempted by 2 students.
Sign up free to check your answer
Sign up freeLoading lesson…

