FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
IF function makes use of something called
A
functional operators
B
relational operators
C
relational database
D
absolute reference
Explanation: 

Detailed explanation-1: -Relational operators compare numeric, character string, or logical data. The result of the comparison, either true ( 1 ) or false ( 0 ), can be used to make a decision regarding program flow (see the IF statement).

Detailed explanation-2: -Relational Expressions A logical expression is a statement that evaluates to either “true” or “false.” Relational operators are a type of logical operator, and compare two values such as 5 > 4 (true) or 3 ≤ −4 (false). matlab returns a 1 to indicate true and 0 to indicate false.

Detailed explanation-3: -== is the equality operator. This returns true if both the operands are referring to the same object, otherwise false.

Detailed explanation-4: -Relational Operators are the operators used to create a relationship and compare the values of two operands. For example, there are two numbers, 5 and 15, and we can get the greatest number using the greater than operator (>) that returns 15 as the greatest or larger number to the 5.

Detailed explanation-5: -If you need to change the execution of the program based on a certain condition you can use “if” statements. The relational operators determine the relationship that one operand has to the other. Specifically, they determine equality condition.

There is 1 question to complete.