What feature allows a worksheet to update calculated fields automatically while being edited?

• A. Manual refresh
• B. Auto-refresh upon changes
• C. Auto-save feature
• D. Conditional formatting

Answer: (B)

The feature that enables a worksheet to update calculated fields automatically while being edited is the auto-refresh upon changes. This functionality ensures that any changes made to input data or dependent fields prompt an immediate recalculation of the relevant formulas or calculated fields. As a result, users can instantly see the effects of their edits, making the worksheet dynamic and responsive to real-time data alterations.

In contrast, manual refresh would require users to manually trigger an update, meaning that they wouldn't see changes in calculated fields until they take that additional step. The auto-save feature is related to data preservation rather than dynamic updates during editing, and conditional formatting pertains to the visual customization of cells based on certain criteria, rather than the updating of calculated values. Therefore, the auto-refresh upon changes is the essential feature that maintains real-time accuracy in calculated fields during the editing process.