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]
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: -For an OR function to be TRUE, at least one of its arguments must be TRUE. The NOT function takes only one argument and essentially changes a single TRUE value to FALSE or a single FALSE value to TRUE.

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