Examveda
Examveda

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 of above

D. None of above

Answer: Option B

Solution(By Examveda Team)

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.

This Question Belongs to Computer Fundamentals >> MS Excel

Join The Discussion

Comments ( 2 )

  1. Nit Computer
    Nit Computer :
    1 year ago

    In Excel 2010, Excel 2013, and Excel 2016, go to File > Options > Formulas > Calculation options section > Workbook Calculation.
    In Excel 2007, click Office button > Excel options > Formulas > Workbook Calculation.
    In Excel 2003, click Tools > Options > Calculation > Calculation.

  2. Prabin Chandra
    Prabin Chandra :
    3 years ago

    It is in the tools menu not in file Menu,, so the answer is d..

Related Questions on MS Excel