DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=MAX( )
|
|
|
=AVG( )
|
|
|
=MIN( )
|
|
|
=LOW( )
|
Detailed explanation-1: -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.
Detailed explanation-2: -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-3: -Returns the smallest number in a set of values.
Detailed explanation-4: -We use the MIN function to return the minimum value in a range of cells in Excel. But if we want to return the minimum or lowest value based on single criteria then we use the MIN function with IF function in an array formula because there is no built-in function in Excel.