DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=SUM(A1;B1)
|
|
|
=SQRT(A1)
|
|
|
=A1^1/B1
|
|
|
=AVERAGE(A1;B1)
|
Detailed explanation-1: -To find the smallest value (the minimum) among a list of numbers, it is necessary to go through the whole list of numbers and compare their values one after the other. The minimum in the list is the smallest value found when all values have been compared.
Detailed explanation-2: -MIN will return the minimum value in a given list of arguments. From a given set of numeric values, it will return the smallest value. Unlike the MINA function, the MIN function ignores numbers, text, and logical values TRUE and FALSE and text values.
Detailed explanation-3: -The MIN function checks your data range and returns the smallest value in the set. Its syntax is the following: MIN(number1, [number2], …) number1, [number2], … is the series of values from where you want to get a minimum.