Copying formulas and locking references

What you will be able to do

Copy a formula down a column, predict what happens to its references, and use $ to hold one of them still.

You wrote the line total once. Now it needs to be on all twelve rows, and the branch manager wants a tax-inclusive column that uses one rate stored in one place. This is where most people's first spreadsheet quietly breaks.

Step 1 of 6 · 1 point

G2 holds =E2*F2. Copy it down to G13 so every order has a line total.