DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
> or »
|
|
|
=>
|
|
|
; or:
|
|
|
; or =
|
Detailed explanation-1: -=OR(A2>=10, B2<5) The formula returns TRUE if A2 is greater than or equal to 10 or B2 is less than 5, or both conditions are met. If neither of the conditions it met, the formula returns FALSE. XOR. Returns a logical Exclusive Or of all arguments.
Detailed explanation-2: -The OR function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE. One common use for the OR function is to expand the usefulness of other functions that perform logical tests.
Detailed explanation-3: -Answer: The result of Boolean value is either true or false.
Detailed explanation-4: -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, "")