FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function that is used to find the lowest value of a set of data is called a function ____
A
Max function
B
Min function
C
Averange function
D
Product function
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: -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. Unlike the MINA function, the MIN function ignores numbers, text, and logical values TRUE and FALSE and text values.

Detailed explanation-3: -Returns the smallest number in a set of values.

Detailed explanation-4: -Python min() Function The min() function returns the item with the lowest value, or the item with the lowest value in an iterable.

Detailed explanation-5: -Explanation: The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values, get the smallest value.

There is 1 question to complete.
Previous
Next