DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
min function
|
|
|
sum function
|
|
|
MAX function
|
|
|
Fungsi 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 returns the smallest value of the selected column.
Detailed explanation-3: -Returns the smallest number in a set of values.
Detailed explanation-4: -The MIN function returns the smallest numeric value in the data provided. The MIN function can be used to return the smallest value from any type of numeric data. For example, MIN can return the fastest time in a race, the earliest date, the smallest percentage, the lowest temperature, or the bottom sales number.
Detailed explanation-5: -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.