DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IF
|
|
|
UNKNOWN
|
|
|
NEW
|
|
|
None of the above
|
Detailed explanation-1: -IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE. As you see, IF takes a total of 3 arguments, but only the first one is obligatory, the other two are optional.
Detailed explanation-2: -The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition.
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: -Technically, the AND function tests the conditions you specify and returns TRUE if all of the conditions evaluate to TRUE, FALSE otherwise.
Detailed explanation-5: -The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.