← My dashboard
EXAM 005
Exam: the fair's cash box
Excel · Module 1 · Exam+200 XP
Professor Owl · Treasury
The science fair closes its books.
No help. Complete the science fair sheet: amounts, the booth commission (cell G1) and the total collected.
Task 1 of 3 · cells D2:D5
In D2:D5 calculate the amount for each booth (Tickets × Price).
Key facts
- Commission in G1
- No help
🎓 Exam with no help. You can try it as many times as you like.
D2fx
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Booth | Tickets | Price | Amount | Commission | Commission | 0.1 |
| 2 | Robots | 42 | 2 | ||||
| 3 | Chemistry | 35 | 2.5 | ||||
| 4 | Planetarium | 58 | 3 | ||||
| 5 | Volcanoes | 27 | 1.5 | ||||
| 6 | Total |
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.