USING MICROSOFT EXCEL
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: -Arithmetic operators follow the same precedence rules as in mathematics, and these are: exponentiation is performed first (when available), multiplication and division are performed next, addition and subtraction are performed last.
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–.