DATABASE FUNDAMENTALS
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.
|
|
logical test
|
|
|
mathematical test
|
|
|
equation
|
|
|
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: -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-3: -IF Formula The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.
There is 1 question to complete.