USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To display the lowest value in a range of values the functon is
|
|
Min
|
|
|
Minimum
|
|
|
Smallest
|
|
|
Lowest
|
Explanation:
Detailed explanation-1: -The MIN function checks your data range and returns the smallest value in the set. Its syntax is the following: MIN(number1, [number2], …) number1, [number2], … is the series of values from where you want to get a minimum.
Detailed explanation-2: -Returns the smallest number in a set of values.
Detailed explanation-3: -The MIN() function returns the smallest value of the selected column.
Detailed explanation-4: -The MIN function is a premade function in Excel, which finds the lowest number in a range. The function ignores cells with text. It will only work for cells with numbers. Note: There is another function called MAX, which finds the highest value in a range, the opposite of MIN.
There is 1 question to complete.