Paper 1 · ICT
UGC NET June 2024 Re-Exam (22.08.2024) Shift-I
Consider an MS-Excel worksheet where cells A1 to A6 contain 90, 60, 150, 30, 50, 130 and cells B1 to B6 contain 70, 170, 20, 110, 40, 30. What will be the value of cell C1 containing the formula =SUMIF(A1:A6,">100",B1:B6)?
A90
B390
C50 ✓ Correct
D420
Correct answer: (C) 50 — The value of cell C1 is 50, so that is the answer.
Explanation
★The value of cell C1 is 50, so that is the answer.
★SUMIF adds values in the sum range where the criteria range meets the condition.
★The condition is that a cell in A1 to A6 is greater than 100.
★In column A only 150 and 130 are greater than 100.
★These are in rows 3 and 6, whose B values are 20 and 30.
★So the sum is 20 plus 30, which is 50.
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