Where can you change automatic or manual calculation mode in Excel?

A) Double CAL indicator on status bar

B) Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button

C) Both (A) and (B)

D) None of the above

Correct Answer : Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button

Explanation : When you press F9 or click Calc Sheet on the Calculation tab on the Tools/Options menu. Calculation also occurs every time that you save the file if you have the checkbox “Recalculate workbook before saving” checked under File > Options > Formulas.