Player Team Goals Scored
Messi Barcelona 42
Rooney Man Utd 27
Ronaldo Madrid 39
Larson Sunderland 12
Torres Chelsea 3
Xavi Barcelona 10
Instructions
Puyol Barcelona 4 Write SUMIF formula into cells D18 to D22 to total up the n
Richardson Sunderland 8 scored for each of the football teams.
Benzima Madrid 19
Drogba Chelsea 21
Giggs Man Utd 6
Hernandez Manutd 17
Total Goals:
Barcelona
Man Utd
Sunderland
Chelsea
Madrid
Instructions
cells D18 to D22 to total up the number of goals
ball teams.
Name Gender Age
Paul Male 51
Sophie Female 23
Ahmed Male 17
Lauren Female 12
Habiba Female 15
Gary Male 32
John Male 41 Instructions
Jeff Male 46 Write SUMIF formula into cell D18 and D 19 to total up the ac
Nour Female 39 males and females.
Mostafa Male 21
Ray Male 12
Hannah Female 13
Total Ages of:
Male
Female
Instructions
and D 19 to total up the accumulative ages of
Code Species MaxSize PH Size Bare Pot Soil
Al Alder 2 Alkaline 2 £0.73 £0.12 £0.68
Al Alder 2 Alkaline 3 £0.95 £0.40 £0.88
Al Alder 2 Alkaline 4 £1.09 £0.80 £1.01
As Ash 3 Alkaline 3 £0.95 £0.40 £0.88
As Ash 3 Alkaline 4 £1.09 £0.80 £1.01
Be Beech 3 Alkaline 2 £0.77 £0.12 £0.71
Be Beech 3 Alkaline 3 £1.20 £0.40 £1.11
Be Beech 3 Alkaline 4 £1.57 £0.80 £1.46
SB Silver Birch 3 Acid 2 £0.79 £0.12 £1.00
SB Silver Birch 3 Acid 3 £1.00 £0.40 £1.27
SB Silver Birch 3 Acid 4 £1.10 £0.80 £1.40
SC Sweet Chestnut 3 Acid 2 £0.80 £0.12 £1.02
SC Sweet Chestnut 3 Acid 3 £1.00 £0.40 £1.27
SC Sweet Chestnut 3 Acid 4 £1.45 £0.80 £1.84
HC Horse Chestnut 3 Alkaline 2 £0.78 £0.12 £0.72
HC Horse Chestnut 3 Alkaline 3 £1.08 £0.40 £1.00
HC Horse Chestnut 3 Alkaline 4 £1.21 £0.80 £1.12
Li Lime 3 Alkaline 2 £0.87 £0.12 £0.81
Li Lime 3 Alkaline 3 £1.08 £0.40 £1.00
Li Lime 3 Alkaline 4 £1.44 £0.80 £1.34
Wa Walnut 1 Neutral 3 £2.53 £0.40 £2.53
FM Field Maple 2 Alkaline 2 £0.75 £0.12 £0.70
FM Field Maple 2 Alkaline 3 £0.95 £0.40 £0.88
FM Field Maple 2 Alkaline 4 £1.10 £0.80 £1.02
Oa Oak 3 Alkaline 2 £0.80 £0.12 £0.74
Oa Oak 3 Alkaline 3 £1.12 £0.40 £1.04
Sy Sycamore 2 Neutral 2 £0.73 £0.12 £0.73
Sy Sycamore 2 Neutral 3 £0.82 £0.40 £0.82
Sy Sycamore 2 Neutral 4 £0.96 £0.80 £0.96
Wi Willow 2 Neutral 2 £0.87 £0.12 £0.87
Wi Willow 2 Neutral 3 £0.96 £0.40 £0.96
Wi Willow 2 Neutral 4 £1.02 £0.80 £1.02
Ye Yew 2 Alkaline 2 £3.85 £0.12 £3.57
Ye Yew 2 Alkaline 3 £4.76 £0.40 £4.42
Pp Poplar 3 Alkaline 3 £1.09 £0.40 £1.01
Pp Poplar 3 Alkaline 4 £1.25 £0.80 £1.16
Cost
£0.80
£1.28 Total Cost of:
£1.81 Alder
£1.28 Beech
£1.81 Ash
£0.83 Silver Birch
£1.51 Sweet Chestnut
£2.25 Lime
£1.12 Walnut
£1.67 Field Maple
£2.19 Oak
£1.14 Sycamore
£1.67 Willow
£2.64 Yew
£0.84 Poplar
£1.40
£1.92
£0.93 Instructions
£1.40 Write SUMIF formula into cell M5 to total up the accumulative cost of Alder trees.
£2.13 Use appropriate absolute and relative cell referencing to allow you to use autofil to
£2.93 complete the accumulative costs for the rest of the trees.
£0.82
Find out how to format cells M5 to M17 to currency and 2 decimal places.
£1.28
£1.82
£0.86
£1.44
£0.85
£1.22
£1.76
£0.99
£1.36
£1.82
£3.69
£4.82
£1.41
£1.96