Paper 1 · ICT
UGC NET December 2023 Re-Exam (14.12.2023) Shift-I
Consider an MS-Excel worksheet where column B holds 'Number of classes taught' and column C holds 'Payments made at Rs 1500 per class' for six months: January (20, 30000), February (14, 21000), March (17, 25500), April (13, 19500), May (12, 18000), June (15, 22500). What value is returned by the function = SUMIFS(C2:C7, B2:B7, ">13", C2:C7, ">22500")?
A78000
B76500
C99000
D55500 ✓ Correct
Correct answer: (D) 55500 — The function returns 55500, so that is the answer.
Explanation
★The function returns 55500, so that is the answer.
★SUMIFS adds values in a range that meet all the given conditions.
★The first condition keeps rows where classes taught are greater than 13.
★These are January 20, February 14, March 17 and June 15.
★The second condition keeps only payments greater than 22500, that is January 30000 and March 25500.
★Their sum is 30000 plus 25500, which is 55500.
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