Paper 1 · ICT
UGC NET December 2023 (19.12.2023) Shift-II
Consider an MS-Excel sheet where column A holds Product Code, column B holds State and column C holds Quality, with rows: (A1, HP, A), (A2, MP, A), (A3, UP, A), (A4, UP, B), (A5, UP, B). Which of the following Excel formulae would correctly answer 'How many product codes from UP are of Grade A quality?' Choose the correct answer from the options given below.
- 1. = COUNTIFS(B2:B6, "=UP", C2:C6, "=A")
- 2. = COUNTIFS(C2:C6, "=A", B2:B6, "=UP")
- 3. = COUNTIFS(B2:B6, "UP", C2:C6, "A")
A1 and 2 only
B1 and 3 only
C2 and 3 only
D1, 2 and 3 ✓ Correct
Correct answer: (D) 1, 2 and 3 — All three COUNTIFS formulas give the correct count, so the answer is 1, 2 and 3.
Explanation
★All three COUNTIFS formulas give the correct count, so the answer is 1, 2 and 3.
★COUNTIFS counts cells that meet several conditions across matching ranges.
★It needs paired range and criteria arguments, here for state UP and quality A.
★The order of the range and criteria pairs does not change the result.
★So swapping the UP condition and the A condition still counts the same cells.
★Each valid formula returns the number of UP rows that are also grade A.
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