DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sum
|
|
|
Min
|
|
|
Max
|
|
|
Average
|
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 is a premade function in Excel, which finds the lowest number in a range. It is typed =MIN. 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.
Detailed explanation-4: -The MIN() function returns the smallest value of the selected column.
Detailed explanation-5: -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.