Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

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

  2. 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

    View Answer

    Workspace

    Answer : Option B

    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.


Be The First To Comment