Microsoft Excel
Excel basics
Microsoft Excel
Excel basics
Excel basics
In D2, calculate the line total for the notebooks (quantity × unit price)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Qty | Unit price | Line total |
| 2 | Notebooks | 12 | 3.5 | |
| 3 | Pens (box) | 5 | 8 | 40 |
| 4 | Folders | 20 | 1.25 | 25 |
| 5 | Subtotal | 107 | ||
| 6 | Discount | 0.1 | ||
| 7 | Tax rate | 0.08 | ||
| 8 | Amount due |
Tip: after typing =SUM( you can click cells to insert their references, just like in the real app.
0/6 steps done