A | B | C | D | E | |
---|---|---|---|---|---|
1 | Code | Item | Price | Quantity | Total cost |
2 | Orange juice | $6.99 | $6.99 | ||
3 | Chocolate bar | $2.99 | $2.99 | ||
4 | Orange juice | $6.99 | $6.99 | ||
5 | Honey Tea | $4.50 | $4.50 | ||
6 | Coffee | $8.25 | $8.25 | ||
7 | Orange juice | $6.99 | $6.99 | ||
8 | Earl Gray Tea | $8.75 | $8.25 | ||
9 | Orange juice | $6.99 | $6.99 | ||
10 | |||||
11 | Total | $51.95 |
A small coffee shop allows staff to enter a menu code and a quantity into a spreadsheet. The spreadsheet will automatically update the price of the individual order and the total price of all orders.
It is Sunday morning and as you can see, only a few orders have been entered into the spreadsheet.
Play with the functionality of the spreadsheet and complete this form.