USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
left to right
|
|
right to left
|
|
from the center out
|
|
None of the above
|
Detailed explanation-1: -If a formula contains operators with the same precedence-for example, if a formula contains both a multiplication and division operator-Excel evaluates the operators from left to right. To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first.
Detailed explanation-2: -Left-associative operators of the same precedence are evaluated in order from left to right. 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.
Detailed explanation-3: -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–.