Asked by Mollie Weber on Apr 28, 2024
Verified
Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas.She does not want to update the data tables on the worksheet, but she does want to update the other formulas.Which of the following is the most efficient way for her to do so?
A) Select the Automatic Except for Data Tables option.
B) Select the Manual Calculation option and recalculate each cell.
C) Retype each formula.
D) Create custom number formats for the cells with formulas.
Data Tables
Structures in software and databases designed to organize, store, and manage data in rows and columns for easy retrieval and analysis.
- Acquire skills in managing and enhancing the performance of Excel workbooks.
- Comprehend the differences between manual and automatic calculation modes in Excel.
Verified Answer
HL
Hannah LudwigMay 03, 2024
Final Answer :
A
Explanation :
By selecting the Automatic Except for Data Tables option, Laura can update the formulas without also updating the data tables on the worksheet. This is the most efficient option as it allows for automatic updating of formulas without the need to manually recalculate each cell or retype each formula. Creating custom number formats is not relevant to the issue of formula updating.
Learning Objectives
- Acquire skills in managing and enhancing the performance of Excel workbooks.
- Comprehend the differences between manual and automatic calculation modes in Excel.