Briefly discuss the order of operations.

What will be an ideal response?

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of operations that you use in algebra. Moving from left to right in a formula, theorder of operationsis as follows: first negation (-), then all percentages (%), then all exponentiations (^), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (-).

As in algebra, you can use parentheses to override the order of operations. For example, if Excel follows the order of operations, 8 * 3 + 2 equals 26. If you use parentheses, however, to change the formula to 8 * (3 + 2), the result is 40, because the parentheses instruct Excel to add 3 and 2 before multiplying by 8.