FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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 TRUE Function[1] is categorized under Excel Logical functions. It will return the logical value of TRUE. The function is equivalent to using the Boolean value TRUE directly in a formula.

There is 1 question to complete.
Previous
Next