What you will practise
A dollar before C fixes the column; a dollar before 1 fixes the row. This task also checks the formula after copying down, right and diagonally.
$C2 * D$1 · $ locks only the coordinate immediately after itThe syntax above is a guide. Read the data and each task to choose the right arguments for your formula.
3 exercises in this lesson
- Exercise 1 · answer in E10
Multiply C2 by D1. Lock input column C and rate row 1 so copying down and right uses the next quantity and rate.
- Exercise 2 · answer in E10
Multiply C3 by D2. Lock input column C and rate row 2, allowing quantity rows and rate columns to move.
- Exercise 3 · answer in E10
Sum C2:C4 and multiply by D1. Lock column C in both range endpoints and rate row 1; copied rows must advance the three-row window.
Before you check your answer
- Keep the source data intact. Write your answer in the highlighted result cell. Changing a source value changes the question instead of solving it.
- Use the requested cells. Check the first and last row of a range and read its column heading. A plausible total can still come from the wrong data.
- Reference values that can change. A fixed number may match today's sheet. A cell reference keeps the formula connected when the source values change.
How the answer is checked
The workbook evaluates your formula against the requested result. It also checks the skill being practised and tests the formula with changed source data, so a fixed answer that happens to match is not enough.
Use progressive hints when you need help, then try the task again with fresh data. Correctly solving a step opens the next exercise.
The workbook opens with this skill selected. Work through the exercises at your own pace.