Page 427 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 7: Watch Window
While working with a large dataset sometimes you might need to look over some cell values immediately and
all time in a specific space. For that, you can add a watch window at the top of the spreadsheet. Here, we have
calculated the total monthly payment amount using the SUM function in Excel. Now we will add a watch window
for this specific cell.
• Choose a cell (C12), apply the below formula, and hit ENTER.
=SUM(E5:E9)

• Now choosing the cell (C12), hit the Watch Window feature from the Formulas tab.

• Within a glimpse, a window will open at the top of the spreadsheet showing cell value and formula. This watch
window is really a helpful tool for making a summary of your dataset. And if you scroll or jump to another sheet
the watch window will always be visible on that place.

412
CITS : IT & ITES - Computer Software Application - Exercise 69