DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -An IF function in Excel consists of 3 components: A logical test, using an operator sign for logical comparison; A value to return if the logical test results in TRUE; A value to return if the logical test results in FALSE.
Detailed explanation-3: -The “IF” function (also called: “If Statement") is composed of three parts separated by commas: A condition, what to display if the condition is met, and what to display if the condition isn’t met.
Detailed explanation-4: -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.