Course
Absolute references practice exercises
Five exercises, from locking one rate to filling a whole quote grid with a single formula. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the absolute references tutorial
Exercise 1 of 5
Lock the commission rate
Fill C2:C6 with each salesperson’s commission: sales times the rate in E1. Write the formula once in C2, lock the rate with $, then copy it down (Ctrl + D).
| Salesperson | Sales ($) | Commission ($) | Commission rate | 5% |
| Olivia Reed | 18,450.00 | |||
| James Carter | 23,900.00 | |||
| Sofia Patel | 15,275.00 | |||
| Liam Brooks | 31,200.00 | |||
| Emma Hughes | 9,800.00 |