"Range Finder" in Excel

What is this term I keep hearing about and how would a CFA use it strategically?

  1. View the Excel spreadsheet for which you wish to use range finder.
  2. Double-click a cell. Range finder activates.
  3. View the other cells associated with your selected cell’s formula range. Notice that the cells in the equation and the actual cells are color-coded.

Oh I see now, thanks!

  1. View the Excel spreadsheet for which you wish to use range finder.
  2. Double-click a cell. Range finder activates.
  3. View the other cells associated with your selected cell’s formula range. Notice that the cells in the equation and the actual cells are color-coded.