Where does that cell get its data from?: Tracking down cell precedents

- [Instructor] We're looking at a worksheet … that's a bit of a mess. … It's a work in progress, … we're trying to figure out what's going on. … We have figured out that cell L23, … the one with the yellow background, is important. … It's our grand total here, … and what we'd like to find out … is where is this cell getting its data from? … Let me zoom in on this using control and the mouse wheel. … I'll double-click that cell, … and we see that it's picking data … from either cell L11 or cell K23. … Okay, let's press Escape. … We can go to that cell just to the left, K23. … I'll double-click there, … and we see that that's getting data out of two other cells. … The process of trying to figure out all the different cells … that contribute to this total is going to take us some time, … and in larger worksheets than this, … imagine the task at hand. … So the term we're looking for here … is the opposite of what we call a dependent. … In some situations, what we'd like to do is to say, …