Accountancy Part CSpreadsheet

______ is the function which adds the cells as per given specified cr…

______ is the function which adds the cells as per given specified criteria.

Answer & explanation

Correct answer: option 4

The correct answer is Option (4) → SUMIF

SUMIF adds only those cells in a range that meet a condition, written as SUMIF(range, criteria, sum_range). IF only tests a condition and returns one of two values, and COUNTIF counts the cells meeting a condition instead of adding them. There is no function called WHATIF; what-if analysis is a separate set of tools.

NCERT (2026-27 edition):
Mathematical Function – “… 1. SUMIF is the function which adds the cells as per given specified criteria the syntax of this is as follows: SUMIF (range, criteria, sum_range) where Range it is the range of cells to evaluate.”