Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data.How can he work more efficiently?
A) Select the Manual Calculation option.
B) Use the Quick Analysis tool to control calculations.
C) Round all the decimal values.
D) Remove any Date functions.

Question

Quizplus · Accepted Answer

By selecting the manual calculation option, Patrick can control when the worksheet updates and prevent the slow updating when he changes data. This allows him to work more efficiently by only calculating the formulas when he wants to.

Patrick Is Editing a Worksheet with Many Formulas and Functions