USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AVERAGE
|
|
|
MIN
|
|
|
MAX
|
|
|
SUM
|
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: -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.
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.
Detailed explanation-5: -For example, suppose we have data from A2:B6 and need to determine the minimum values. In such a scenario, we can use the MIN Excel function. In this example, applying the MIN function formula =MIN(A2:B6) may give us the minimum value among the cell range from A2 to B6.