DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What formula function will determine the smallest value in a range?
|
|
=min(range),
|
|
|
=max(range),
|
|
|
=average(range),
|
|
|
=smallest(range)
|
Explanation:
Detailed explanation-1: -The MIN function checks your data range and returns the smallest value in the set.
Detailed explanation-2: -For example, if you have a list of numbers in a column and you want to find the smallest number in the list, you can use the MIN function to do so. To use the MIN function, type “=MIN(range of cells)” into a cell, where “range of cells” is the range of cells that you want to calculate the minimum value for.
Detailed explanation-3: -Returns the smallest number in a set of values.
There is 1 question to complete.