Which function returns the smallest value?
MIN()
In a spreadsheet program such as MS Excel, statistical functions operate on a range of cells or a list of numbers. The function that returns the smallest (minimum) numerical value from a set is MIN().
Syntax: =MIN(number1, [number2], ...) — the arguments can be individual numbers, cell references, or a range such as A1:A10. Excel scans all the numeric values and returns the lowest one.
Worked example: =MIN(5, 3, 8, 1, 9) compares the values and returns 1, the smallest number in the list.
It helps to contrast MIN() with the related aggregate functions so the distinction is clear:
| Function | What it returns |
|---|---|
| MIN() | The smallest value in the range |
| MAX() | The largest value in the range |
| AVERAGE() | The arithmetic mean (sum ÷ count) of the values |
| COUNT() | How many cells in the range contain numbers |
Therefore the other choices are wrong: MAX() gives the largest value (the opposite of what is asked), AVERAGE gives the mean rather than an extreme value, and COUNT() gives a tally of numeric entries, not any actual data value.
Similar Questions
You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?
What file extension is used to save an MS PowerPoint 2021 presentation?
Which function returns the smallest value?
If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
Which function returns the smallest value?
You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?
If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
What file extension is used to save an MS PowerPoint 2021 presentation?
You want to automatically advance slides with narration and animations during a presentation. Which MS PowerPoint feature should you use to achieve this?
If cell A1 = 10 and B1 = 20, what will `=A1+B1` return?
Important Questions from Microsoft Office
In MS-PowerPoint, which key on the keyboard can be used to view slide show?
Considering the content of the first cell of a worksheet as 10, the value of the Excel formula = $A$1/4 is:
In MS-PowerPoint, slide show options available to the presenter include all of the following, except for:
______ and _______ are the smallest and largest font size available in Font Size tool on formatting toolbar in MS-Office.
Which of the following features is used to apply motion effects in between slide exits and another enters?
