Lesson
Cell references & fill down
When you copy a formula down a column, the cell references shift with it. =B2*C2 becomes =B3*C3 one row down. This is called a relative reference, and it is why one formula can fill a whole table.
5 quick steps, about 4 minutes.