← My dashboard
SHEET 001
The trip expenses
Excel · Module 1 · Operations+50 XP
Professor Owl · Treasury
The museum field trip has to add up.
The Academy's Treasury is planning the field trip to the science museum. Each expense has units and a price, but the total of each line is missing.
Goal · cells D2:D6
In the Total column (D2:D6) calculate Units × Price for each line.
Key facts
- Total = Units × Price
- Every formula starts with =
D2fx
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Units | Price | Total |
| 2 | Bus | 2 | 85 | |
| 3 | Tickets | 30 | 4.5 | |
| 4 | Meals | 30 | 7.2 | |
| 5 | Insurance | 1 | 40 | |
| 6 | Supplies | 15 | 2.4 |
The cells with a dotted border are the ones you must fill in. Separate arguments with , or ;
🎯 Each marked cell has to be a formula that calculates the correct result.