DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sum
|
|
|
Max
|
|
|
Min
|
|
|
Average
|
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: -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-3: -Returns the smallest number in a set of values.
Detailed explanation-4: -The MIN() function returns the smallest value of the selected column.
Detailed explanation-5: -You can find this minimum value by graphing the function or by using one of the two equations. If you have the equation in the form of y = ax^2 + bx + c, then you can find the minimum value using the equation min = c-b^2/4a.