USING MICROSOFT EXCEL
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Pixel
|
|
background
|
|
Condition
|
|
None of these answers
|
Detailed explanation-1: -Relational operators are used for comparing the values. It either returns True or False according to the condition. These operators are also known as Comparison Operators.
Detailed explanation-2: -Relational operators compare two values to determine if the relational expression is TRUE or FALSE. Much like arithmetic operators (+, -, *, /, etc.), relational operators appear between two operands, which can either be numerical constants, Boolean values, text values, cell references, or nested formulas/functions.
Detailed explanation-3: -However, & always evaluates both of its operands and returns true if both are true . Likewise, when the operands are boolean, | performs the same operation as || . The | operator always evaluates both of its operands and returns true if at least one of its operands is true .
Detailed explanation-4: -The relational operators enable you to compare the expressions on either side of the operator. A condition involving a single relational expression is called a simple condition. A condition involving two or more relational expressions joined by logical operators is called a complex condition.