Consider the following Ms - Excel work sheet:

 

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
78000
2
76500
3
99000
4
55500

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation