Consider the following snapshot of MS-Excel worksheet: 

 

A

B

C

D

17

Day

Quantity

Sales Amount (Rs.) 

 

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 ____.

**Note - In Question Paper the formula was given:- = SUMIFS (C18 ∶ C23, B18 ∶ B23, "3", C18 ∶ C23, ">500", which was wrong, so we have made some changes in question to make it correct.**

1
1466
2
2140
3
1773
4
26

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation