Administration and Executive AssistantTier 130 minbeginner

Relative References: One Formula, Filled Down

Write one formula for the first row and fill it down, so every row works out its own answer.

What you will learn

• See how a relative reference (A2) becomes A3, A4 and so on when filled down
• Do the steps in the order the brief gives: tax on gross first, then deductions
• Treat a blank cell as zero in arithmetic
• Check the last row as well as the first; locking cells with $ comes in lesson 10

Excel skills

Relative references, fill down, order of operations · Cell References

The task

I need net pay for the twenty people on the Payroll tab by end of day. The rule from finance is: take gross, apply the tax rate, then subtract deductions. In that order. Deductions come off after tax, not before.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free