In this short blog, i will explain trace precedents feature of microsoft excel 2010.
let me explain what is the purpose of this. it tells what other cells affect the value of currently selected cell.
lets explain it through images.
write any two numbers in the cells, and take there sum in another cell. Select the Sum cell and go to the formulas tab, click Trace Precedents (highlighted in the picture) and it will make a line from formula cell to the dependent cells.