Paper 1 · ICT
UGC NET June 2023 (19.06.2023) Shift-I
In an MS Excel spreadsheet of 100 customers, column C is the payment category, where 0 means discounted price and 1 means full price. Statement I: The formula =COUNTIFS(C2:C101, "0") counts all customers who get a discounted price. Statement II: The formula =COUNTIF(C2:C101, "=0") counts all customers who get a discounted price. In the light of the above statements, choose the correct answer from the options given below.
- Statement I: The formula =COUNTIFS(C2:C101, "0") counts all customers who get a discounted price.
- Statement II: The formula =COUNTIF(C2:C101, "=0") counts all customers who get a discounted price.
ABoth Statement I and Statement II are true ✓ Correct
BBoth Statement I and Statement II are false
CStatement I is true but Statement II is false
DStatement I is false but Statement II is true
Correct answer: (A) Both Statement I and Statement II are true — Both formulas count the discounted customers, so the answer is that both statements are true.
Explanation
★Both formulas count the discounted customers, so the answer is that both statements are true.
★A discounted customer is one whose payment category in column C equals 0.
★COUNTIFS counts cells that meet one or more conditions across ranges.
★With the single range and the criterion 0, COUNTIFS counts all cells in column C equal to 0.
★COUNTIF counts cells that meet a single condition in one range.
★With the criterion equal to 0, COUNTIF also counts all cells in column C equal to 0.
★So both formulas correctly count the customers who get a discounted price.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Shared by Mcqkart · via Mcqkart.in