They are smart enough to go through an Excel spreadsheet ... If you select a cell and trigger the function, Excel points an arrow to any formula that is using the value in that particular cell.