DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Insert a formula that returns the smallest number from column D.
|
|
=MAX
|
|
|
=MIN
|
|
|
=SUM
|
|
|
=SUMIF
|
Explanation:
Detailed explanation-1: -Returns the smallest number in a set of values.
Detailed explanation-2: -To return the lowest value from a range of cells we use the Excel MIN function. But, if we need to get the minimum value based on criteria then Excel does not have a built-in function for that. However, we can return the minimum value if criteria match by using the MIN and IF functions together in an array formula.
There is 1 question to complete.