USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which formula gets the smallest value of a range of cells?
|
|
MAX
|
|
|
MIN
|
|
|
SMALL
|
|
|
SUM
|
Explanation:
Detailed explanation-1: -Returns the smallest number in a set of values.
Detailed explanation-2: -The MIN Function[1] is categorized under Excel Statistical functions. MIN will return the minimum value in a given list of arguments. From a given set of numeric values, it will return the smallest value.
Detailed explanation-3: -To use the MIN function, type “=MIN(range of cells)” into a cell, where “range of cells” is the range of cells that you want to calculate the minimum value for. Excel will then return the smallest number in the range.
There is 1 question to complete.