Going to the cinema.xlsx

	B	C	D	E	F	G
1
2	Going to the cinema - Aberystwyth Arts Centre
3
4
5	Ticket	1	9	43	76	99
6	Full price
7	Senior
8	Under 18
9	12yrs and under
10	Total
11
12	1. Enter the price of one ticket of each different type in the spreadsheet.
13
14	2. Use a formula to calculate how much 9 of each type of ticket would be.
15
16	3. Use a formula to calculate how much 43 of each type of ticket would be.
17
18	4. Use a formula to calculate how much 76 of each type of ticket would be.
19
20	5. Use a formula to calculate how much 99 of each type of ticket would be.
21
22	6. Calculate the total cost of each amount of the different ticket types.
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