You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a
sales report in Microsoft Excel. The report contains many worksheets. Martha has used many
formulas in her report. She wants to monitor a cell which contains a formul
A.
The formula refers to many other cells that are located in different worksheets in the report. She
wants to know the effects on the cell when the values in different sheets change. She requests that
you help her out to accomplish the task. Which of the following steps would you suggest she take in
order to accomplish the task?
Click the New Window option in the Window group on the View tab.
Click the Arrange All option in the Window group on the View tab.
Select the Vertical option.
A.
The formula refers to many other cells that are located in different worksheets in the report. She
wants to know the effects on the cell when the values in different sheets change. She requests that
you help her out to accomplish the task. Which of the following steps would you suggest she take in
order to accomplish the task?
Click the New Window option in the Window group on the View tab.
Click the Arrange All option in the Window group on the View tab.
Select the Vertical option.
B.
Click the New Window option in the Window group on the View tab.
Click the Arrange All option in the Window group on the View tab.
Select the Cascade option.
C.
Select the cell which is to be monitored.
On the Formulas tab in the Formula Auditing group, click Watch Window.
Click Add Watch.
D.
Select the cell which is to be monitored.
On the Formulas tab in the Formula Auditing group, click Evaluate Formula.
Explanation:
In order to accomplish the task, she should take the following steps:
Select the cell which is to be monitored.
On the Formulas tab in the Formula Auditing group, click Watch Window.
Click Add Watch.