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]
With the ____ function, only one of the arguments has to be true for the function to return a TRUE value.
A
OR
B
NOT
C
AND
D
IF
Explanation: 

Detailed explanation-1: -If anything evaluates to TRUE, then the function will return TRUE; to return FALSE, every argument in the function must evaluate to FALSE. Even if only one argument in this function evaluates to TRUE, the function will return TRUE. This is the sister function to the AND function.

Detailed explanation-2: -If we type =TRUE() in a cell, we get the result as TRUE. One can also enter TRUE function directly into a cell. Even if we do not add the parentheses, it will return the Boolean value TRUE.

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: -Using the OR function in Excel The difference is that the OR function returns TRUE if at least one if the arguments evaluates to TRUE, and returns FALSE if all arguments are FALSE.

There is 1 question to complete.
Previous
Next