DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
multiplication
|
|
|
division
|
|
|
subtraction
|
|
|
None of the above
|
Detailed explanation-1: -2. Addition and subtraction operations are applied next. If an expression contains several such operations, the operators are applied from left to right. Addition and subtraction operators have the same level of precedence.
Detailed explanation-2: -The subtraction is performed before the addition as subtraction and addition have the same precedence, so ClearSCADA performs them in the order they appear from left to right.
Detailed explanation-3: -For example, addition and subtraction have the same precedence and they are left-associative. In the expression 10-4+2, the subtraction is done first because it is to the left of the addition, producing a value of 8. Right-associative operators of the same precedence are evaluated in order from right to left.
Detailed explanation-4: -The order of operations says that operations must be done in the following order: parentheses, exponents, multiplication, division, addition, and subtraction.
Detailed explanation-5: -The logical-AND operator ( && ) has higher precedence than the logical-OR operator ( || ), so q && r is grouped as an operand. Since the logical operators guarantee evaluation of operands from left to right, q && r is evaluated before s–.