USING MICROSOFT EXCEL
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 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: -The MIN() function returns the smallest value of the selected column.
Detailed explanation-3: -What is the MIN Function? 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-4: -To find the minimum value of a column, use the MIN() aggregate function; it takes as its argument the name of the column for which you want to find the minimum value. If you have not specified any other columns in the SELECT clause, the minimum will be calculated for all records in the table.
Detailed explanation-5: -What Is The Difference Between SQL LEAST and MIN? There are a few differences between the SQL LEAST and MIN functions: Both MIN and LEAST will return one result, but MIN is an aggregate function and LEAST is not. LEAST can return multiple rows.