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 ________ .
- A.
1466
- B.
2140
- C.
1773
- D.
26
Attempted by 8 students.
Sign up free to check your answer
Sign up freeLoading lesson…

