DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Alex wants to find the lowest value in a range of cells. Which of the followingfunctions should he use?
|
|
=MIN( )
|
|
|
=MAX( )
|
|
|
=AVERAGE( )
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -To return the lowest value from a range of cells we use the Excel MIN function.
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.
There is 1 question to complete.