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.

Question

Quizplus · Accepted Answer

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.

Laura Is Changing Data in a Worksheet, but the Worksheet