Information Technology Spreadsheet

Domino Books (Wales) Ltd
P O Box 32 Swansea
United Kingdom SA1 4QN
Tel. 01792 459378
Fax. 01792 466337
International Tel.
+44 (0) 1792 459378
email: sales@dominobooks.co.uk

	HOME	FIRST STEPS	MASTER FILES
	DYLAN THOMAS CORNER	ACTIVITY PACKS	HERITAGE/TOURIST BOOKS
	LITERACY	NUMERACY
*View Shopping Basket*

View Sample Pages 1 2 3

SAMPLE PAGE KS2 ICT SPREADSHEETS AND DATA HANDLING

THE FOOTBALL STORE

	A	B	C	D	E	F
1
2	Item	Price (£)	Number bought	Cost (£)	Paid with	Change
3	Tee shirt	5.25
4	Shorts	6.35
5	Boots	11.99
6	Football	7.99
7	Cap	3.45
8			Total

Set up the spreadsheet on your computer.
John bought 3 tee shirts, two pairs of shorts, a pair of boots and a cap.
Type this information into the spreadsheet and find out how much John spent.

He handed the shop assistant £50. Type this in E8.
The change should appear in F8.
Save your work.

Formulae

=B3*C3

and pull fill handle down to D7.

D8 Select D3 to D7 and click Autosum button to give the total John spent.

=E8-D8

View Sample Pages 1 2 3

Entering data in a spreadsheet and using it to calculate sales in a football shop.
From Master File, ICT, Spreadsheets and Handling Data, Key Stage 2 for 7-11 year olds.