DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
AND
|
|
OR
|
|
IF
|
|
SUM
|
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.