Page 421 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 2: Trace Dependents

In order to visually highlights the cells that depend on the value of a selected cell, you can try the Trace
Dependents feature in Excel. This is a powerful tool for understanding the relationship between cells. Here,
let’s see how the interest rate is dependent on the cells.
• Simply, choose a cell (C11), and then visit the Trace Dependents feature from the Formulas tab.

• Finally, you will see the arrows from the cell (C11) to other cells indicating the cells that are dependent on the value
of the selected cell.

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