Computer · MS Excel
Consider the following MS Excel worksheet data: Row 18: Monday, Quantity (B18) = 1, Sales Amount (C18) = 234 Row 19: Tuesday, Quantity (B19) = 3, Sales Amount (C19) = 144 Row 20: Wednesday, Quantity (B20) = 6, Sales Amount (C20) = 367 Row 21: Thursday, Quantity (B21) = 5, Sales Amount (C21) = 674 Row 22: Friday, Quantity (B22) = 8, Sales Amount (C22) = 1099 Row 23: Saturday, Quantity (B23) = 3, Sales Amount (C23) = 233 What is the value returned by the Excel formula =SUMIFS(C18:C23, B18:B23, ">3", C18:C23, ">500")?
- 11466
- 22140
- 31773✓
- 426
Correct answer
1773
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on MS Excel?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer · MS Excel