USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the Excel function used to provide the greatest value?
|
|
LOWER
|
|
|
MIN
|
|
|
MAX
|
|
|
GREATEST
|
Explanation:
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: -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.
There is 1 question to complete.