Exercise 1 of 4
Calculate the first line total
In D2, calculate the notebook line total using the quantity in B2 and price in C2.
Lesson progress0 of 4 complete 0%
Intro to Excel / Lesson 1 of 3
Relative and absolute references
Price an order correctly, even when quantities or discounts change.
Your scenario
Price an office supplies order
You handle purchasing for a small team.
A supplier has quoted prices for your next stationery order. You need a total for each item before you can approve the spend. Later, the supplier offers one discount for the whole order. Can your formulas keep up without fixing every row by hand?
Work through the briefSupplier quote
| Item | Quantity | Unit price | Line total |
|---|---|---|---|
| Notebook | 3 | $8 | ? |
| Pen pack | 5 | $4 | ? |
| Folder | 2 | $11 | ? |
What will each item cost?One formula you can reuse across the order.
Need a quick refresher?
B2 means column B, row 2. The * symbol multiplies. A formula such as =B2*C2 reads the values in those cells. A percentage of 10% is stored as 0.1.
Put it into practice
Work through the brief
Take it back to work
What would you do differently?
Compare your thinking
Each copied formula would keep reading the original row instead of using the inputs on its own row.