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 Automatic Except for Data Table Manual   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