FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ function returns TRUE if all its arguments are true, and FALSE if one or more arguments are false.
A
AND
B
OR
C
IF
D
NOT
Explanation: 

Detailed explanation-1: -The AND function returns TRUE if all its arguments evaluate to TRUE and returns FALSE if one or more arguments evaluate to FALSE. One common use of the AND Function is to expand the usefulness of other functions that perform logical tests.

Detailed explanation-2: -The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand the usefulness of other functions that perform logical tests.

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.

Detailed explanation-4: -Syntax. 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.

Detailed explanation-5: -The AND function in Excel checks if every argument you put in it evaluates to TRUE. If everything evaluates to TRUE, then the function will return TRUE, otherwise, even if only one argument is FALSE, the function will return the value FALSE.

There is 1 question to complete.
Previous
Next