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. | Customr Name | Customer Category | Payment Category | Price (Rs.) |
| 2. | Raman | Child | 0 | 0 |
| 3. | Dinesh | Adult | 1 | 5 |
| 4. | Jashan | Adult | 0 | 2 |
| - | - | - | - | - |
| 101 | Amt | Child | 0 | 0 |
Statement (I): The formula = COUNTIFS (B2:B101,"Adult") counts all customers who are adults.
Statement (II): The formula = COUNTIFS (B2:101,"Adult") counts all customers who are adults.
In light of the above statements, choose the most appropriate answer from the options given below.
1
Both Statement (I) and Statement (II) are true.
2
Both Statement (I) and Statement (II) are false
3
Statement (I) is true but Statement (II) is false.
4
Statement (I) is false but Statement (II) is true.