FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A logical test is a condition or ____ whose result is either true or false.
A
EXPRESSION
B
RANGE
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -A Boolean expression is a logical statement that is either TRUE or FALSE . Boolean expressions can compare data of any type as long as both parts of the expression have the same basic data type. You can test data to see if it is equal to, greater than, or less than other data.

Detailed explanation-2: -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: -A logical condition is an expression formed by some variables and some relational, equality and logical operators.

Detailed explanation-4: -The condition is a Boolean expression: an expression that evaluates to either true or false . Boolean values are another type of data type in programming languages, and they can only ever hold true or false.

Detailed explanation-5: -The logical OR operator ( || ) returns the boolean value true if either or both operands is true and returns false otherwise. The operands are implicitly converted to type bool before evaluation, and the result is of type bool .

There is 1 question to complete.
Previous
Next