DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Knowing the smallest value
|
|
|
Knowing the greatest value
|
|
|
Know the highest score
|
|
|
Find out the lowest score
|
Detailed explanation-1: -MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.
Detailed explanation-2: -Explanation: To find the maximum, we must find where the graph shifts from increasing to decreasing. To find out the rate at which the graph shifts from increasing to decreasing, we look at the second derivative and see when the value changes from positive to negative.
Detailed explanation-3: -The max() function returns the largest item in an iterable. It can also be used to find the largest item between two or more parameters.