Formula Calculations

These lessons have focused on formulas and more formulas. By default, the workbook calculations are automatic.


Try it: Enable the Calculations

Open any sample spreadsheet you created in the previous lessons.

Go to Formulas ->Calculation.

Click on Calculation Options.


What Do You See? The options include:


Automatic Except for Data Table


What Else Do You See? The little buttons to the right of Calculation Options are:

Calculate Now

Calculate Sheet


These buttons are useful when the Calculation is set to Manual.

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.2. Manipulate formula options: Enable Automatic Calculation Options

Formulas ->Calculation->Calculation Options