Which tool in MS Excel is used to monitor the values of certain c
A. <span lang="EN" style=" line-height: 115%; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Recently used</span>
B. <span lang="EN" style=" line-height: 115%; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Background</span>
C. <span lang="EN" style=" line-height: 115%; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Hyperlink</span>
D. <span lang="EN" style=" line-height: 115%; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Watch window</span>
E. <span lang="EN" style=" line-height: 115%; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;">Slicer</span>
Please scroll down to see the correct answer and solution guide.
Right Answer is: D
SOLUTION
The correct answer is Watch window
- Watch window allows you to view the contents of any cell and the results of any dynamic formulas as you make changes to other parts of the worksheet.
- This window allows you to monitor the output generated from formulas as you make changes to other parts of the workbook.
- This watch window will even work if you have cell references between the workbook and you are changing the value in the original workbook.
- This provides remote viewing of multiple cells on any open worksheet and provides dynamic data about each formula including, its location and its residing value.