Course
First formulas
Put the basics to work on a small order sheet: multiply, copy down, total, average and round.
Exercise 1 of 5
Your first formula
In D2, multiply the quantity in B2 by the unit price in C2. Every formula starts with =, and * means multiply.
| Item | Qty | Unit price ($) | Line total ($) |
| Notebooks | 12 | 2.50 | |
| Pens (box) | 4 | 6.90 | |
| Stapler | 2 | 14.00 | |
| Printer paper | 10 | 5.75 | |
| Desk tray | 3 | 18.40 |