ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Jaycee's Birthday Party Plan
Instructions: help Jaycee plan her daugther's birthday party. She has invited 10 children.
2
ItemQuantity ( for 10 people)Tesco PriceTotal1. Go to www.tesco.com and find the prices for each item of food (column C).
3
Birthday cake 1£6.50£6.50
4
Popcorn 22. Calculate the total price for each item. The first one has been done for you.
5
Crisps 1
6
Chicken nuggets (pack of 20)
23. Calculate the total cost for this shop
7
Chips (McCain 1 KG)24. Format the spreadsheet (text size, colours, wident the columns).
8
Cucumbers (x3)3 You have 30 minutes to complete this task.
9
Chocolate fingers (Cadbury)
2
10
Lemon Squash (1 Litre)
1
11
Orange Squash (1 litre)
1EXTENSION:
12
Party hats (pack of 10)
21. Copy and paste the row headers in row 2 in row 16.
13
Party poppers (6 pack)
22. Then copy and paste all the food items in colum A in cell 17A.
14
Total3. Now change Tesco price to another supermarked of your choice: Asda, Sainsbury's.
15
4. Fill in the prices for each item and calculate the costs.
16
5. Which supermarket is cheaper?
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100