DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To calculate the highest value in a range we use the formula____
|
|
=AVERAGE()
|
|
|
=MAX()
|
|
|
=MIN()
|
|
|
=ROUND()
|
|
|
=SUM()
|
Explanation:
Detailed explanation-1: -Returns the largest value in a set of values.
Detailed explanation-2: -The largest value in a data set is often called the maximum (or max for short), and the smallest value is called the minimum (or min). The difference between the maximum and minimum value is sometimes called the range and is calculated by subtracting the smallest value from the largest value.
Detailed explanation-3: -A global maximum of a function is the largest value in the entire range of the function, and a local maximum is the largest value in some local neighborhood., the extremum test succeeds under more general conditions than the second derivative test.
There is 1 question to complete.