FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A ____, which is made up of two values and a relational operator, is true or false for each cell in the range.
A
Pixel
B
background
C
Condition
D
None of these answers
Explanation: 

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.

There is 1 question to complete.