USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the output of the function =if(A1=A2, “Unequal", “Equal")when A1=10 A2 = 11
|
|
None of these
|
|
|
Error
|
|
|
Equal
|
|
|
Unequal
|
Explanation:
Detailed explanation-1: -=A1*A2 multiplies the values in A1 and A2. =A1/A2 divides the value in A1 by A2. There are also many functions you can use inside formulas. See a list of formulas here.
Detailed explanation-2: -In Excel, <> means not equal to. The <> operator in Excel checks if two values are not equal to each other. Let’s take a look at a few examples.
Detailed explanation-3: -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, "")
There is 1 question to complete.