FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Fungsi OR
A
Returns FALSE if every argument is TRUE
B
Returns TRUE if every argument is TRUE
C
Returns TRUE if any argument is FALSE
D
Returns TRUE
Explanation: 

Detailed explanation-1: -Technical Details. 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-2: -The OR function in Excel checks if ANY argument in it evaluates to TRUE. 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.

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: -The AND function in Excel is a logical function that checks whether all arguments fed into the function are TRUE and returns “TRUE” if all arguments are TRUE.

Detailed explanation-5: -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. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

There is 1 question to complete.
Previous
Next