Page 249 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Trace Precedents

Trace Precedents is a dynamic tool to sort out the complex
chain of cell relationships in your spreadsheets. Trace
Precedents provide you the ability to understand formula
dependencies by highlighting the connections that have
an impact on a chosen cell. As we have calculated the
interest amount by multiplying the principal amount with
the interest rate, let’s see what the trace precedent tool
show for this calculation.
• To do so, choose a cell (D5), and visit the Trace
Precedents option from the Formulas tab.

• As a result, we will see two arrows from cell (C5) and
cell (C11) indicating towards cell (D5) as the interest
amount is calculated using the principal amount and
interest rate.

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.

236

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77