DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sum
|
|
|
Max
|
|
|
Average
|
|
|
Min
|
Detailed explanation-1: -The MAX Function[1] is categorized under Excel Statistical functions. 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.
Detailed explanation-2: -Returns the largest value in a set of values.
Detailed explanation-3: -If the cells are in a contiguous row or column, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.
Detailed explanation-4: -If you are given the formula y = ax2 + bx + c, then you can find the maximum value using the formula max = c-(b2 / 4a). If you have the equation y = a(x-h)2 + k and the a term is negative, then the maximum value is k.
Detailed explanation-5: -The Excel MAX Formula is used to find out the maximum value from a given set of data/ array. MAX function in Excel returns the highest value from a given set of numeric values. Excel MAX formula will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.