DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the correct function for finding the lowest or smallest number in a range?
|
=SUM(C1:C23)
|
|
=AVERAGE(C1:C23)
|
|
=MAX(C1:C23)
|
|
=MIN(C1:C23)
|
Explanation:
Detailed explanation-1: -The MIN function in Excel is used to find the smallest value in a given range of cells.
Detailed explanation-2: -Returns the smallest number in a set of values.
Detailed explanation-3: -What is the SMALL Function? The SMALL Function[1] is categorized as an Excel Statistical function. It will return numeric values based on their position in a list, ranked by value. Essentially, it calculates and returns the k smallest value in a dataset.
There is 1 question to complete.