USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUM
|
|
|
AVERAGE
|
|
|
MAX
|
|
|
MIN
|
|
|
IF
|
Detailed explanation-1: -The MAX function in Excel returns the highest value in a set of data that you specify. The syntax is as follows: MAX(number1, [number2], …) Where number can be represented by a numeric value, array, named range, a reference to a cell or range containing numbers.
Detailed explanation-2: -Use the Maximum in group function in a query or situation to compare the attributes returned and select the one with the highest value. For attributes that return multiple rows, the MAX function finds the highest returned value (or values).
Detailed explanation-3: -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.