DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
This function finds the smallest number in a range.
|
|
FV
|
|
|
Average
|
|
|
Max
|
|
|
Min
|
Explanation:
Detailed explanation-1: -The MIN function is a premade function in Excel, which finds the lowest number in a range. It is typed =MIN. 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 returns the smallest value of the selected column.
There is 1 question to complete.