Page 104 - Excel Workbook for Dummies

10_798452 ch05.qxp 3/13/06 7:44 PM Page 87
Chapter 5: Building Formulas 87
Verify that Excel has automatically recalculated the formulas in both your
Formulas and Ext Ref worksheets and that cell C9 on the Formulas sheet and B3
on the Ext Ref sheet now both contain the same value: 1,816,854.91.
2. Select the Manual option button on the Calculation tab of the Options dialog box
(Tools➪Options).
3. Update the value in cell A2 of the Formulas sheet from 102 to 144.
Note that none of the calculated values in the Formulas sheet have been updated
(C9 still contains 1,816,854.91) and that the Calculate indicator has now
appeared on the Status bar.
4. Select the Calc Sheet button on the Calculation tab of the Options dialog box.
Note that Excel recalculates the formulas on the Formulas worksheet and that
cell C9 now contains the value 4,412,310.20, but that the Calculate indicator has
not disappeared from the Status bar. Then, switch to the Ext Ref sheet and note
that the linked formula in cell B3 has not been updated and still contains the
value 1,816,854.91.
5. Press F9 to have Excel recalculate all the formulas in the entire workbook.
Note that not only does cell B3 of the Ext Ref worksheet now contains the
updated value 4,412,310.20, but that the Calculate indicator has now disappeared
from the Status bar.
6. Switch back to the Formulas worksheet, and then update cell A2 to 165.88 before
you press F9.
Check to make sure that all the formulas on both sheets of the workbook have
now been updated by verifying that both cell C9 in the Formulas sheet and B3 in
the Ext Ref sheet now contain 6,423,962.85.
7. Update cell A2 in the Formulas worksheet to 188 and then save this change to
the Practice Formulas.xls workbook.
Note that Excel not only saves your change to cell A2 in Practice Formulas.xls
workbook file, but also recalculates the formulas using this new value and then
saves these updated values as well.

8. Save a copy of this workbook file under the filename Solved5-8.xls in your
Chapter 5 folder inside the My Practice Spreadsheets folder.
Note that any changes you make to the recalculation mode are saved as part of
the workbook file, so that they are in effect the next time anyone opens the file
for editing.