Samira has a workbook containing many worksheets with interconnected formulas. What can she use to display the values of specified cells located throughout the workbook?
A) Observe Formula dialog box
B) Show Formulas command
C) Watch Window
D) Automatic Update Window

Question

Quizplus · Accepted Answer

The Watch Window can be used to display the values of specified cells located throughout the workbook. It allows you to add and monitor cells, ranges, and formulas from different worksheets in one place. The Observe Formula dialog box is used to trace cell references, the Show Formulas command displays all formulas in the worksheet instead of their results, and the Automatic Update Window updates links between workbooks automatically.

Samira Has a Workbook Containing Many Worksheets with Interconnected Formulas