Q19
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
AnswerC.
Both of above
D.
None of above
Answer: Option B
Solution
Answer: Option B
Solution:
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.