FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.