Consider the following MS-Excel worksheet: A B C 1 Month Number of classes…
PYQ UGC NET 2023
Consider the following MS-Excel worksheet:
A | B | C | |
|---|---|---|---|
1 | Month | Number of classes taught | Payments (in ₹) made @ 1500 per class |
2 | January | 20 | 30000 |
3 | February | 14 | 21000 |
4 | March | 17 | 25500 |
5 | April | 13 | 19500 |
6 | May | 12 | 18000 |
7 | June | 15 | 22500 |
The value returned by the function =SUMIFS(C2:C7, B2:B7, ">13", C2:C7, ">22500") is:
- A.
78000
- B.
76500
- C.
99000
- D.
55500
Attempted by 7 students.
Sign up free to check your answer
Sign up freeLoading lesson…

