FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function used to calculate the smallest value of numeric data ____
A
Sum
B
Min
C
Max
D
Average
Explanation: 

Detailed explanation-1: -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-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 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-5: -Detailed Solution. The Excel MIN function returns the smallest value from a supplied set of numeric values.

There is 1 question to complete.