USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
arithmetic
|
|
|
comparison
|
|
|
text concatenation
|
|
|
reference
|
Detailed explanation-1: -A logical operator is used in Excel to compare two values. Logical operators are sometimes called Boolean operators because the result of the comparison in any given case can only be either TRUE or FALSE.
Detailed explanation-2: -Expressions that use comparison operators do not return a number value as do arithmetic expressions. Comparison expressions return either 1, which represents true, or 0, which represents false.
Detailed explanation-3: -The equality operator (==) is used to compare two values or expressions. It is used to compare numbers, strings, Boolean values, variables, objects, arrays, or functions.
Detailed explanation-4: -Comparison Operators Greater than ( > )-returns true if the value on the left is greater than the value on the right, otherwise it returns false . Less than or equal to ( <= )-returns true if the value on the left is less than or equal to the value on the right, otherwise it returns false .
Detailed explanation-5: -The == and === operators check whether two values are the same, using two different definitions of sameness. Both operators accept operands of any type, and both return true if their operands are the same and false if they are different.