Computer Science · MS Excel
Consider the following snapshot of an MS-Excel worksheet: ABCD1Roll NumberTest Marks-1Test Marks-2Total marks220180601403202705012042034030705204303262620585851707206658014582077296168920825325710209907816811210254065 The formula =SUMIF(B2:B11, '<50', D2:D11) in cell D12 will result in:
- 1120
- 2254✓
- 390
- 4244
Correct answer
254
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 Science?
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 Science · MS Excel