DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you change the calculation options in Excel?
|
Right click and select calculation options
|
|
Click change calculations in the data tab
|
|
Click calculation option in the excel options dialog box
|
|
Click the formulas tab then the calculation options button in the calculation group
|
Explanation:
Detailed explanation-1: -In the Excel for the web spreadsheet, click the Formulas tab. Next to Calculation Options, select one of the following options in the dropdown: To recalculate all dependent formulas every time you make a change to a value, formula, or name, click Automatic. This is the default setting.
There is 1 question to complete.