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, the order of operations is 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...
Match the following terms to their meanings:
I. Aggregate function II. Expression Builder III. Property sheet IV. Totals Query V. Syntax A. Performs calculations on a column of data and returns a single value B. Tool used to create complicated expressions C. Contains an additional row that displays aggregate data D. Specifies structure and components for a calculation E. Contains formatting information
All of the following can appear within a document's
element except a(n) ____ element.A. block-level B. text-level C. document head D. inline
What are four characteristics of the model of a physical or social phenomenon?
Fill in the blank(s) with the appropriate word(s).
Click ____ on the shortcut menu to start the TableAdapter Query Configuration Wizard.
A. Add Configuration B. Add Query C. Add Link D. Add TableAdapter