FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The three arguments used in the IF function are: ____, value if true, value if false.
A
logical test
B
mathematical test
C
equation
D
operation
Explanation: 

Detailed explanation-1: -IF is one of the Logical functions in Microsoft Excel, and there are 3 parts (arguments) to the IF function syntax: logical test: TEST something, such as the value in a cell. value if true: Specify what should happen if the test result is TRUE. value if false: Specify what should happen if the test result is FALSE.

Detailed explanation-2: -The function allows the user to put in up to 127 logical test arguments using the IFS function.

Detailed explanation-3: -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.

Detailed explanation-4: -If–then arguments, also known as conditional arguments or hypothetical syllogisms, are the workhorses of deductive logic. They make up a loosely defined family of deductive arguments that have an if–then statement-that is, a conditional-as a premise. The conditional has the standard form If P then Q.

There is 1 question to complete.
Previous
Next