What is the difference between Excel’s calculation modes (Automatic, Automatic Except Tables, Manual) and when would you use Manual?

Question

Microsoft Excel — Hard

What is the difference between Excel’s calculation modes (Automatic, Automatic Except Tables, Manual) and when would you use Manual?

Accepted Answer

Excel's calculation modes dictate when formulas are recalculated. The correct answer, B, accurately describes the distinction between Automatic, Automatic Except Tables, and Manual modes. Manual mode is used to mitigate lag in complex workbooks. This is because it delays recalculation until F9 is pressed.