Consider the following snapshot of an MS-Excel worksheet: A B C D 17 Day…

PYQ UGC NET 2024

Consider the following snapshot of an MS-Excel worksheet:

A

B

C

D

17

Day

Quantity

Sales Amount (₹)

18

Monday

1

234

19

Tuesday

3

144

20

Wednesday

6

367

21

Thursday

5

674

22

Friday

8

1099

23

Saturday

3

233

In cell D18, the value returned by the function

=SUMIFS(C18:C23, B18:B23, ">3", C18:C23, ">500") is ________ .

  1. A.

    1466

  2. B.

    2140

  3. C.

    1773

  4. D.

    26

Attempted by 8 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…