DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If the value of A1 = 3 and B1 = 5, the result with the highest value is ____
|
|
=SUM(A1;B1)
|
|
|
=POWER(A1;B1)
|
|
|
=B1*A1
|
|
|
=AVERAGE(A1;B1)
|
Explanation:
Detailed explanation-1: -Example 3: =MAX(A1:B5)-This Excel function determines the largest value among the numbers in the cell range A1 through B5. Excel returns a value of 923 (cell B3).
Detailed explanation-2: -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-3: -The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.
There is 1 question to complete.