The correct answer is Option (3) → OR
Spreadsheet functions are grouped by what they do. Mathematical functions work on numbers; logical functions test conditions and return only TRUE or FALSE. OR is a logical function: it returns TRUE if any one of its arguments is TRUE.
Option (1) RoundUp — A mathematical function. It rounds a number up, away from zero, to the digits given.
Option (2) Count — A mathematical function. It counts the cells that contain numbers.
Option (4) Sum IF — A mathematical function. SUMIF adds the cells that meet a given criterion.
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: …” NCERT (2026-27 edition):
Mathematical Function – “… ROUNDUP (number, num_digits) which rounds a number up, away from 0 (zero) e.g.” NCERT (2026-27 edition):
Mathematical Function – “… 3. COUNT This function counts the number of cells that contain numbers and counts numbers within the list of arguments. COUNT is use to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers.” NCERT (2026-27 edition):
Logical Function – “… 2. OR function is like other logical functions, the OR function gives only a TRUE or FALSE answer. To determine whether the output will be TRUE or FALSE, the OR functions evaluates at least one mathematical expression located in another cell in the spreadsheet. This function returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.” |
