ExamVeda
Login
Home
This question belongs to Computer Fundamentals MS Excel
MS Excel
?

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

Answer & Solution
Correct Answer: Option B
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

2 Comments
Nit Computer
Nit Computer 4 years 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.
Prabin Chandra
Prabin Chandra 5 years ago
It is in the tools menu not in file Menu,, so the answer is d..