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:

  1. A.

    78000

  2. B.

    76500

  3. C.

    99000

  4. D.

    55500

Attempted by 7 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…