DATABASE FUNDAMENTALS
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: -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-2: -Finding max/min value in a group by applying pivot table. There is another way that can quickly find the max or min value in each group by inserting a pivot table. 5. Click OK to close the dialog.
Detailed explanation-3: -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-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.