What auditing tool is best used to monitor the changes in a cell over time?
A)Trace precedents
B)Watch Window
C)Trace dependents
D)Formula bar

Question

Quizplus · Accepted Answer

The Watch Window is the best tool to monitor the changes in a cell over time. It allows you to add cells to a watch list, and then you can monitor the values of those cells as they change over time. It is especially useful for cells that are dependent on other cells, as you can easily see how changes in one cell affect the values of other cells. The other options listed, such as Trace precedents, Trace dependents, and the Formula bar, can also be useful auditing tools, but they do not specifically allow you to monitor changes over time like the Watch Window does.

What Auditing Tool Is Best Used to Monitor the Changes