What if we changed it?
Answers are for parents and teachers.
1
A bakery stall: profit = (price − cost) × sold. Buns cost 1 and sell at 2.5. 20 are sold. What is the profit? What if the price rises to 3?
(2.5 − 1) × 20 = 30. With a price of 3: (3 − 1) × 20 = 40.
2
In the stall sheet, which cells change if the card cost in B4 changes?
E4 changes (its formula uses B4) and E5 changes (it adds E4). Everything else stays the same.
3
Pages per day × 6 = total pages read. Fill in the three goal seek items for a goal of 90 pages, and solve it.
Set cell: total pages. To value: 90. By changing cell: pages per day. 90 ÷ 6 = 15. Check: 15 × 6 = 90.
4
A model gives profit = 0.50 × sold. The goal is 20. How many must be sold? Show the check.
20 ÷ 0.50 = 40. Check: 0.50 × 40 = 20.
5
Give one thing a spreadsheet model might leave out, and say why that matters.
It may leave out that fewer people buy when the price goes up. If the model ignores it, a what-if result for a higher price may be too high.