Activity 2 - Party planning.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Ingredient	Measured in	Choc-chip muffins	Blueberry muffins	Cupcakes	Chocolate cake	DF chocolate cake	DF chocolate cupcakes	DF choc-chip cookie bars	Maximum	Minimum	Total

2	Baking powder	tsp	3	2		1
3	Baking soda	tsp					1		1
4	Blueberries	g		125
5	Brown sugar	g							148
6	Butter	g		75	125	125
7	Caster sugar	g	250	125	125	75	175	175
8	Chocolate chips	g	100						175
9	Cocoa powder	g				50	15	30
10	Eggs		2	2	2	2		3	2
11	Honey	tbsp				2
12	Icing sugar	g			225
13	Margarine	g			125			175	165
14	Milk	ml	250	300		150
15	Plain chocolate	g				75		75
16	Plain flour	g	400	275			200		355
17	Salt	tsp	1						1
18	Self-raising flour	g			125	150		150
19	Vanilla essence	tsp				1	1	1	2
20	Vegetable oil	ml	125				75
21	Vinegar	tsp					1
22	Water	ml					225
23			Number of ingredients in each recipe:
24
25
26			Total number of ingredients listed in column A:
27
28	Instructions & tips
29	Your task is to use functions to fill in the shaded cells above.
30
31	Maximum and minimum:
32	For each ingredient, what is the biggest amount any of the recipes need of it (use the MAX function), and what is the smallest amount (use the MIN function)?
33
34	Total
35	Imagine somebody wants to bake one of every recipe on the spreadsheet (for a really big party!). Using the SUM function in the Total column, work out how much of each ingredient they need for doing that. Will 1 litre be enough milk? What about 1kg of caster sugar and 1kg of plain flour?
36
37	Number of ingredients (row 24)
38	Below each recipe, use the COUNTA function to count how many ingredients the recipe uses.
39	Use the column range notation with COUNTA to fill in the total number of ingredients listed in the Ingredient column (column A).
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