Year 5 Spreadsheets - Lesson 1


1	Enter the correct forumula below:
2
3						Answer
4	5	times	5				Enter a formula
5	7	plus	2				Enter a formula
6	13	minus	9				Enter a formula
7	213	plus	3				Enter a formula
8	12	divide by	3				Enter a formula
9	9	times	10				Enter a formula
10	7	times	3				Enter a formula
11	12	plus	9				Enter a formula
12	17	minus	16				Enter a formula
13	200	plus	34				Enter a formula
14	400	divide by	10				Enter a formula
15	15	times	17				Enter a formula
16	12	times	19				Enter a formula
17	3765	plus	456				Enter a formula
18	100	minus	63				Enter a formula
19	13	plus	17				Enter a formula
20	711	divide by	9				Enter a formula
21	22	times	16				Enter a formula
22	12	times	8				Enter a formula
23
24
25	Now a bit harder.......
26
27						Answer
28	2	plus	1	plus	5		Enter a formula
29	7	plus	2	plus	2		Enter a formula
30	13	plus	3	plus	9		Enter a formula
31	213	plus	4	plus	3		Enter a formula
32	12	plus	6	plus	3		Enter a formula
33	9	plus	6	plus	10		Enter a formula
34	7	plus	7	plus	3		Enter a formula
35	12	plus	8	plus	9		Enter a formula
36	17	plus	9	plus	16		Enter a formula
37	200	plus	65	plus	34		Enter a formula
38	400	plus	43	plus	10		Enter a formula
39	15	plus	87	plus	17		Enter a formula
40	12	plus	19	plus	19		Enter a formula
41	3765	plus	33	plus	456		Enter a formula
42	100	plus	18	plus	63		Enter a formula
43	13	plus	10	plus	17		Enter a formula
44	711	plus	54	plus	9		Enter a formula
45	22	plus	25	plus	16		Enter a formula
46	12	plus	12	plus	8		Enter a formula
47
48	Now a bit harder.......
49
50						Answer
51	5	plus	1	minus	5		Enter a formula
52	7	plus	2	minus	2		Enter a formula
53	13	plus	3	minus	9		Enter a formula
54	213	plus	4	minus	3		Enter a formula
55	12	plus	6	minus	3		Enter a formula
56	9	plus	6	minus	10		Enter a formula
57	7	plus	7	minus	3		Enter a formula
58	12	plus	8	minus	9		Enter a formula
59	17	plus	9	minus	16		Enter a formula
60	200	plus	65	minus	34		Enter a formula
61	400	plus	43	minus	10		Enter a formula
62	15	plus	87	minus	17		Enter a formula
63
64
65	Add these numbers together - Think about using the SUM function
66
67						Answer
68	5	4	1	99	5		Enter a formula
69	7	1	2	2	2		Enter a formula
70	13	9	3	5	9		Enter a formula
71	213	2	4	23	3		Enter a formula
72	12	10	6	5	3		Enter a formula
73	9	16	6	4	10		Enter a formula
74	7	17	7	12	3		Enter a formula
75	12	16	8	1	9		Enter a formula
76	17	34	9	21	16		Enter a formula
77	200	10	65	5	34		Enter a formula
78	400	17	43	76	10		Enter a formula
79	15	7	87	2	17		Enter a formula
80
81
82	Can we find the average? - Think about using the AVERAGE function
83
84						Answer
85	5	4	1	99	5		Enter a formula
86	7	1	2	2	2		Enter a formula
87	13	9	3	5	9		Enter a formula
88	213	2	4	23	3		Enter a formula
89	12	10	6	5	3		Enter a formula
90	9	16	6	4	10		Enter a formula
91	7	17	7	12	3		Enter a formula
92	12	16	8	1	9		Enter a formula
93	17	34	9	21	16		Enter a formula
94	200	10	65	5	34		Enter a formula
95	400	17	43	76	10		Enter a formula
96	15	7	87	2	17		Enter a formula
97
98
99	Can we find the LARGEST and SMALLEST numbers? (MAX and MIN)
100
101						Largest		Smallest
102	5	4	1	99	5		Enter a formula		Enter a formula
103	7	1	2	2	2		Enter a formula		Enter a formula
104	13	9	3	5	9		Enter a formula		Enter a formula
105	213	2	4	23	3		Enter a formula		Enter a formula
106	12	10	6	5	3		Enter a formula		Enter a formula
107	9	16	6	4	10		Enter a formula		Enter a formula
108	7	17	7	12	3		Enter a formula		Enter a formula
109	12	16	8	1	9		Enter a formula		Enter a formula
110	17	34	9	21	16		Enter a formula		Enter a formula
111	200	10	65	5	34		Enter a formula		Enter a formula
112	400	17	43	76	10		Enter a formula		Enter a formula
113	15	7	87	2	17		Enter a formula		Enter a formula
114
115
116	Can we find the MODE and the MEDIAN from these lists?
117
118						Mode		Median
119	5	4	1	99	5		Enter a formula		Enter a formula
120	7	1	2	2	2		Enter a formula		Enter a formula
121	13	9	3	5	9		Enter a formula		Enter a formula
122	23	2	4	23	3		Enter a formula		Enter a formula
123	12	10	6	5	12		Enter a formula		Enter a formula
124	9	16	6	6	10		Enter a formula		Enter a formula
125	7	17	7	12	3		Enter a formula		Enter a formula
126	12	16	8	16	9		Enter a formula		Enter a formula
127	17	34	9	34	16		Enter a formula		Enter a formula
128	200	10	65	65	34		Enter a formula		Enter a formula
129	400	17	43	76	17		Enter a formula		Enter a formula
130	15	7	87	2	7		Enter a formula		Enter a formula
131
132


1
2	Each square in our spreadsheet is called a:
3
4
5	A spreadsheet is made up of rows and columns.
6		are horizontal
7		are vertical
8
9
10
11	THIS	cell is referred to as:
12
13
14	Enter a formula to add the following two cells:	5	2
15
16	Once completed, go to the 'Formulae' worksheet as you can see below