USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MAX
|
|
|
MIN
|
|
|
LARGE
|
|
|
SUM
|
Detailed explanation-1: -, click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.
Detailed explanation-2: -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-3: -Returns the largest value in a set of values.
Detailed explanation-4: -The largest value in a data set is often called the maximum (or max for short), and the smallest value is called the minimum (or min). The difference between the maximum and minimum value is sometimes called the range and is calculated by subtracting the smallest value from the largest value.