Which of the following is not a mathematical function of spreadsheet/MS Excel?
2025
Which of the following is not a mathematical function of spreadsheet/MS Excel?
- A.
SUMIF()
- B.
TODAY()
- C.
ROUND()
- D.
COUNT()
Attempted by 8 students.
Show answer & explanation
Correct answer: B
CONCEPT: MS Excel offers many built-in functions. Some perform an arithmetic or numeric computation on the values in a range — summing, rounding, or counting how many entries are numbers — and exam-reference material commonly groups these as “mathematical” functions. Others work with a calendar date or clock time instead of computing on numeric cell values at all, forming a separate date-and-time family.
APPLICATION: Checking each option’s own behaviour:
SUMIF(range, criteria, [sum_range]) scans a range, tests each cell against a condition, and adds up the numeric values from the matching cells of the sum range, returning a single summed total — a numeric aggregation.
ROUND(number, num_digits) takes a number and a digit count, and returns that number adjusted to the specified number of decimal places using standard rounding rules — a numeric computation.
COUNT(value1, [value2], …) scans the supplied values or cell range, skipping any text or blank entries, and returns a count of how many entries are numeric — a numeric result produced by counting.
TODAY() takes no arguments at all and returns the current calendar date read from the system clock; the value updates automatically every time the worksheet recalculates — no numbers are summed, rounded, or counted.
CROSS-CHECK: SUMIF(), ROUND(), and COUNT() each end up performing a numeric computation — summing, rounding, or counting — on the values they process. Excel’s own Function Library places SUMIF() and ROUND() under “Math & Trig” and COUNT() under “Statistical”, and both of these are numeric-computation categories distinct from TODAY()’s “Date & Time” category, which is why exam material groups the first three together as mathematical/numeric functions. TODAY() instead returns a date with no arithmetic performed on any sheet values at all. This also matches the official answer key published for this question (RSSB Patwar 2025, Shift 2, Question 116).
So the function that is NOT a mathematical function of spreadsheet/MS Excel is TODAY().