FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
This function checks whether criteria are met and returns one value if TRUE and another value if FALSE
A
IF
B
UNKNOWN
C
NEW
D
None of the above
Explanation: 

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.

There is 1 question to complete.