UGC NET ICT Q23

Question

You are given a list of 100 customers in an MS Excel spreadsheet. Column 'A' contains their names, 'B' is for customer category, 'C' is for payment category (0 means discounted price and 1 means full price), 'D' indicates the price paid by the customer. The example spreadsheet below is not a complete list and only shows different categories.

Statement - I: The formula = COUNTIFS(B2:B101, "Adult") counts all adult customers.
Statement - II: The formula = COUNTIFS(B2:B101,"= Adult") counts all adult customers.

In light of the above statements, choose the most appropriate answer from the options given below:

Accepted Answer

Both Statement I and Statement II are true.