In this worksheet called "Absolute", we're about to put a formula in column…F. We're going to create New Salary simply by giving everybody a $2000 salary increase.…Now, a formula like this involves a standard Excel technique.…If I type = and click cell E3+2000, and after typing this entry, you would want…to copy this down the column.…If you work with Excel formulas a bit, you know Excel will do exactly the right thing here.…In other words, if we complete the formula and drag from the lower right-hand…corner--let's just check it out on a few cells--…Excel is not using E3 over and over and over again.…

It's surely adjusting to using E4 and as I double-click on these, E5 and E6 and…so on, for as far down as we might copy this.…That's called a Relative Reference.…It's the most common kind of reference in Excel--a cell reference…that is relative.…If we copy the formula into different rows, it adjusts the Row Reference of a formula.…Let's take a different situation here where we want everybody's salary to go up…