Name
Produced by Alan Scott, Tollesby School, Middlesbrough
Extra task:
Can you think of a way to improve the look of the spreadsheet, maybe to make it look clearer or neater so that it is easier to read?
A2 = Potatoes
A3 = Carrots
A4 = Peas
A5 = Chicken
C1 = 5.00
B2 = .99
B3 = .45
B4 = .30
B5 = 2.99
C2 = a formula to subtract B2 from C1
C3 = a formula to subtract B3 from C2
C4 = a formula to subtract the cost of the peas from the money in C3
C5 = copy C4
B7 = a formula to work out the cost of the meal
A7 = a label to tell you what B7 is
A8 = Money Left
C8 = =C5
Chicken Dinner
You must budget for the cost of a meal. You have £5.00 to buy a chicken, some potatoes, carrots and peas. Make a spreadsheet to show how much the meal will cost and how much is left. Enter the words and numbers into each cell.