DATABASE FUNDAMENTALS
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–.
Detailed explanation-4: -Excel calculates from left to right, using the PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) order of operations. In other words, it performs calculations in parentheses first, then it checks for multiplication and division, then finally it performs addition and subtraction.