USING MICROSOFT EXCEL
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: -The max() function returns the item with the highest value, or the item with the highest value in an iterable. If the values are strings, an alphabetically comparison is done.
Detailed explanation-3: -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.