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.
You might also like to view...
The ____ container width is the width of the containing box.
A. master B. parent C. baseline D. comprehensive
When working with visual color mixing, which statement is true?
a. The dots of color must touch each other. b. The dots of color must not touch each other. c. You must leave space in between the dots of color.
Categories of data are called ________.
A. fields B. records C. tables D. objects
In a PivotTable, ____ fields correspond to summary values of original data across categories.
A. category B. index C. data D. summary