Scribd
Upload
26 views1 page

Excel 55

This chapter provides instructions for using the Evaluate Formula dialog in Excel and configuring calculation options. It guides the user through setting manual calculation, entering a formula, and addressing circular references. Finally, it instructs on enabling iterative calculations and reverting to automatic settings.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views1 page

Excel 55

This chapter provides instructions for using the Evaluate Formula dialog in Excel and configuring calculation options. It guides the user through setting manual calculation, entering a formula, and addressing circular references. Finally, it instructs on enabling iterative calculations and reverting to automatic settings.

Uploaded by

chhayayadav17072003
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Chapter 3

7. Use the Evaluate Formula dialog to step through the formula in cell C20.

8. Delete the watch you created in step 1.

Configure automatic and iterative calculation options


Open the SetIterativeOptions workbook in Excel, and then perform the following tasks:

1. On the Formulas tab, in the Calculation group, select the Calculation Options
button, and then select Manual.

2. In cell B6, enter the formula =B7*B9, and then press Enter.

3. Note that this result is incorrect because the Gross Savings value minus the
Savings Incentive value should equal the Net Savings value, which it does not.

4. Press F9 to recalculate the workbook and read the message box indicating that
you have created a circular reference.

5. Select OK.

6. Use options in the Excel Options dialog to enable iterative calculation.

7. Close the Excel Options dialog and recalculate the worksheet.

8. Change the workbook’s calculation options back to Automatic.

102

You might also like