USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If the value of A1 = 4 and B1 = 3, the result with the smallest value is ____
|
|
=SUM(A1;B1)
|
|
|
=SQRT(A1)
|
|
|
=A1^1/B1
|
|
|
=AVERAGE(A1;B1)
|
Explanation:
Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-2: -Example 1: =MIN(A1:B5)-This Excel function determines the smallest value among the cell range of A1 to B5. Excel returns a value of 20 (cell A4). Example 2: =MIN(B1:B5, 100)-The arguments in this MIN function include a cell range and a number.
Detailed explanation-3: -The MIN function checks your data range and returns the smallest value in the set. Its syntax is the following: MIN(number1, [number2], …) number1, [number2], … is the series of values from where you want to get a minimum.
There is 1 question to complete.