DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
to find the average value of a variable.
|
|
|
if some arguments are TRUE and FALSE if all arguments are FALSE
|
|
|
TRUE if all the arguments tested evaluate to TRUE and FALSE if all or one of the arguments evaluates to FALSE.
|
|
|
tested FALSE if tested TRUE.
|
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: -IF Formula The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.
Detailed explanation-3: -Using the OR function in Excel As well as AND, the Excel OR function is a basic logical function that is used to compare two values or statements. 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.
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.