USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
TRUE
|
|
FALSE
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Formulas are recalculated automatically every time that a formula changes, and every time that a cell changes that a formula references. This is the default option. Formulas are never re-calculated automatically. A user must select the Calculate Workbook option to recalculate any formulas.
Detailed explanation-2: -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.
Detailed explanation-3: -Explanation: Microsoft Excel automatically recalculates formulas only when the cells that the formula depends on have changed. This is the default behavior when you first open a workbook and when you are editing a workbook. However, you can control when and how Excel recalculates formulas.
Detailed explanation-4: -You must start each formula by typing the equal sign (=). When you change the value in a cell that is referenced in a formula, you must re-enter the formula to make sure it also changes. You can click a cell or select a range to enter its address in the formula. Formulas and functions are NOT case sensitive.