DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MIN
|
|
|
MAX
|
|
|
AVERAGE
|
|
|
COUNT
|
Detailed explanation-1: -Answer: It is true that the Min function is used to find the smallest value in a set of values.
Detailed explanation-2: -Returns the smallest number in a set of values.
Detailed explanation-3: -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-4: -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.