FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What functions checks if a condition is met and returns one value if True or another value if False?
A
SUMIF
B
COUNTIF
C
IF
D
AVERAGEIF
Explanation: 

Detailed explanation-1: -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")

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: -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.

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: -Consequently, in the logical test of your IF formula, you should use one of these functions: AND function-returns TRUE if all the conditions are met; FALSE otherwise. OR function-returns TRUE if any single condition is met; FALSE otherwise.

There is 1 question to complete.