Get Started
337

Q:

There is a table in MS Excel which contains numbers from 0 to 10. If you want to add numbers greater than 5 in that table, then which of the following formula will be suitable?

  • 1
    =SUM(A2:A8)
  • 2
    =SUM(A2:A8,”
  • 3
    =SUMIF(A2:A8,”>0″)
  • 4
    =SUMIF(A2:A8, “
  • Show Answer
  • Workspace

Answer : 3. "=SUMIF(A2:A8,”>0″)"
Explanation :

There is a table in MS Excel which contains numbers from 0 to 10. If you have to add numbers greater than 5 in that table, then the formula =SUMIF (A2:A8,”>0″) is suitable.

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today