FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To compare two or more conditions, to produce a TRUE / FALSE value, use the ____ function.
A
AND
B
OR
C
IF
D
SUM
Explanation: 

Detailed explanation-1: -Nested IF statement to check multiple logical tests Such functions are called nested IF functions. They prove particularly useful when you wish to return different values depending on the logical tests’ results.

Detailed explanation-2: -Use the function EXACT() when you compare two columns in Excel, and you wish to find values that are case sensitive. The EXACT () function compares two text strings and returns TRUE if they are the same and FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. The syntax is =EXACT( text1, text2).

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, "")

Detailed explanation-4: -Technically, the AND function tests the conditions you specify and returns TRUE if all of the conditions evaluate to TRUE, FALSE otherwise.

There is 1 question to complete.