FUNDAMENTALS OF COMPUTER

Previous

USING MICROSOFT EXCEL

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 returns TRUE if any of the arguments are TRUE. The Excel formula for this is =OR(logical1, [logical2], …). In this example the AND function returns TRUE if the first score is greater than or equal to 65 and the second score is greater than or equal to 100, otherwise it returns FALSE.

Detailed explanation-4: -Logical functions provide decision-making tools for information in a spreadsheet. They allow you to look at the contents of a cell, or to perform a calculation, and then test that result against a required figure or value.

There is 1 question to complete.
Previous