FUNDAMENTALS OF COMPUTER

Previous

DATABASE FUNDAMENTALS

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Except for the ____ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
A
IF
B
AND
C
OR
D
NOT
Explanation: 

Detailed explanation-1: -The logical functions provided by MS Excel are AND, OR, XOR, and NOT. The AND function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false. The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.

Detailed explanation-2: -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. IF(logical test, value if true, [value if false])

Detailed explanation-3: -The OR function in Excel either returns a TRUE or a FALSE. It returns FALSE only if all arguments evaluate to FALSE. The function returns TRUE even if a single argument evaluates to TRUE. This logical function will help you compare data and test multiple conditions.

There is 1 question to complete.
Previous