Manchester College Economics Questionnaire

Description

2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2.slider-slide > img { width: 100%; display: block; }
.slider-slide > img:focus { margin: auto; }

Unformatted Attachment Preview

NOTE: The ORIGINAL data in this assessment is sample data and
created for the purpose of this examination which is drawn from
actual statistics drawn compiled by the office for National
Statistics (ONS).
Please enter your STUDENT ID number here to confirm you have read
this disclaimer and that this is your original work
DETAILS OF THE EXAMINATION
Date: 18th January
Total Marks = 110
GUIDE TO THE WORKSHEETS
NOTE: Some of the worksheets are ‘protected’, meaning that you are
restricted on actions you can take, edits and selections. If you are
unable to access a function or cell, it is because there is no need to
rather than because of a workbook problem.
Please save your work at regular intervals and remember to upload the
final version before the deadline.
THE DATA IN THIS DOCUMENT
IS THEREFORE NOT VALID FOR
USE OUTSIDE OF THE TESTING
CONTEXT
Student ID
????????
Each Question has its own data and list of
sub questions that needs to be worked
out as stated in Column B of each
Worksheet
The blue tabs (Question [x]) contain the
instructions for each of the questions
that make up the paper. The number in
brackets on the tab represents the
number of marks allocated to each
question
If you want to add any comments, please
use the yellow tab (Comments). This will
not be marked, but it will help avoid
interference and can be used to clarify
any issues you have as you do the exam.
ANSWERS MUST BE
DONE ON THIS
WORKSHEET
Item number
Instruction
a
Please autofit the width of Column F OF THE TABLE so you can
read the information it contains
b
Apply the £ currency format in cells I11:I661
c
Apply Red- White- Green Colour Scales conditional formatting
to the values in column I
d
Fill colour orange and embellish the fonts to italics for cells F11
to I11 (as also shown in Cell D10)
e
Use a ‘freeze pane’ to freeze the top row.
f
Reorder the worksheet so Question 3 (33) is the last
g
Fill in the data for the respective cells in the table using Excel
formulae (i.e. calculate the values of the average and minimum
etc for Employment and Turnover) in cells L12 to M13 and
replace the question marks
h
For the Employment data (Column H ), using appropiate function
to calculate the count of the values that are greater than 100
using cells H12 to H661 and write this function in cell N12
i
Create the table using Gold, Table Style Medium 5 from cell
range F11 to I662. Ensure that you treat the first row (Row 11)
as the header information
TOTAL
]
Marks Allocated
3
3
3
3
Column1
3
Berwick-upon-Tweed
Bishop Auckland
3
10
Blaydon
Blyth Valley
City of Durham
7
Darlington
Easington
5
Gateshead
Hartlepool
Hexham
40
Houghton and Sunderland South
Jarrow
Middlesbrough
Middlesbrough South and East
Cleveland
Newcastle upon Tyne Central
Newcastle upon Tyne East
Newcastle upon Tyne North
North Durham
North Tyneside
North West Durham
Redcar
Sedgefield
South Shields
Stockton North
Stockton South
Sunderland Central
Tynemouth
Wansbeck
Washington and Sunderland West
Altrincham and Sale West
Ashton-under-Lyne
Barrow and Furness
Birkenhead
Blackburn
Blackley and Broughton
Blackpool North & Cleveleys
Blackpool South
Bolton North East
Bolton South East
Bolton West
Bootle
Burnley
Bury North
Bury South
Carlisle
Cheadle
Chorley
City of Chester
Congleton
Copeland
Crewe and Nantwich
Denton and Reddish
Eddisbury
Ellesmere Port and Neston
Fylde
Garston and Halewood
Halton
]
Hazel Grove
Heywood and Middleton
Hyndburn
Knowsley
Lancaster and Fleetwood
Leigh
Liverpool – Riverside
Liverpool – Walton
Liverpool – Wavertree
Liverpool – West Derby
Macclesfield
Makerfield
Manchester Central
Manchester – Gorton
Manchester – Withington
Morecambe and Lunesdale
Oldham East and Saddleworth
Oldham West and Royton
Pendle
Penrith and The Border
Preston
Ribble Valley
Rochdale
Rossendale and Darwen
Salford and Eccles
Sefton Central
South Ribble
Southport
St Helens North
St Helens South and Whiston
Stalybridge and Hyde
Stockport
Stretford and Urmston
Tatton
Wallasey
Warrington North
Warrington South
Weaver Vale
West Lancashire
Westmorland and Lonsdale
Wigan
Wirral South
Wirral West
Workington
Worsley and Eccles South
Wyre and Preston North
Wythenshawe and Sale East
Barnsley Central
Barnsley East
Batley and Spen
Beverley and Holderness
Bradford East
Bradford South
Bradford West
Brigg and Goole
Calder Valley
Cleethorpes
Colne Valley
Dewsbury
Don Valley
Doncaster Central
Doncaster North
East Yorkshire
Elmet and Rothwell
Great Grimsby
Halifax
Haltemprice and Howden
Harrogate and Knaresborough
Hemsworth
Huddersfield
Keighley
Kingston upon Hull East
Kingston upon Hull North
Kingston upon Hull West and
Hessle
Leeds Central
Leeds East
Leeds North East
Leeds North West
Leeds West
Morley and Outwood
Normanton; Pontefract and
Castleford
Penistone and Stocksbridge
Pudsey
Richmond (Yorks)
Rother Valley
Rotherham
Scarborough and Whitby
Scunthorpe
Selby and Ainsty
Sheffield Central
Sheffield South East
Sheffield – Brightside and
Hillsborough
Sheffield – Hallam
Sheffield – Heeley
Shipley
Skipton and Ripon
Thirsk and Malton
Wakefield
Wentworth and Dearne
York Central
York Outer
Amber Valley
Ashfield
Bassetlaw
Bolsover
Boston and Skegness
Bosworth
Broxtowe
Charnwood
Chesterfield
Corby
Daventry
Derby North
Derby South
Derbyshire Dales
Erewash
Gainsborough
Gedling
Grantham and Stamford
Harborough
High Peak
Kettering
Leicester East
Leicester South
Leicester West
Lincoln
Loughborough
Louth and Horncastle
Mansfield
Mid Derbyshire
Newark
North East Derbyshire
North West Leicestershire
Northampton North
Northampton South
Nottingham East
Nottingham North
Nottingham South
Rushcliffe
Rutland and Melton
Sherwood
Sleaford and North Hykeham
South Derbyshire
South Holland and The Deepings
South Leicestershire
South Northamptonshire
Wellingborough
Aldridge-Brownhills
Birmingham – Edgbaston
Birmingham – Erdington
Birmingham – Hall Green
Birmingham – Hodge Hill
Birmingham – Ladywood
Birmingham – Northfield
Birmingham – Perry Barr
Birmingham – Selly Oak
Birmingham – Yardley
Bromsgrove
Burton
Cannock Chase
Coventry North East
Coventry North West
Coventry South
Dudley North
Dudley South
Halesowen and Rowley Regis
Hereford and South Herefordshire
Kenilworth and Southam
Lichfield
Ludlow
Meriden
Mid Worcestershire
Newcastle-under-Lyme
North Herefordshire
North Shropshire
North Warwickshire
Nuneaton
Redditch
Rugby
Shrewsbury and Atcham
Solihull
South Staffordshire
Stafford
Staffordshire Moorlands
Stoke-on-Trent Central
Stoke-on-Trent North
Stoke-on-Trent South
Stone
Stourbridge
Stratford-on-Avon
Sutton Coldfield
Tamworth
Telford
The Wrekin
Walsall North
Walsall South
Warley
Warwick and Leamington
West Bromwich East
West Bromwich West
West Worcestershire
Wolverhampton North East
Wolverhampton South East
Wolverhampton South West
Worcester
Wyre Forest
Basildon and Billericay
Bedford
Braintree
Brentwood and Ongar
Broadland
Broxbourne
Bury St Edmunds
Cambridge
Castle Point
Central Suffolk and North Ipswich
Chelmsford
Clacton
Colchester
Epping Forest
Great Yarmouth
Harlow
Harwich and North Essex
Hemel Hempstead
Hertford and Stortford
Hertsmere
Hitchin and Harpenden
Huntingdon
Ipswich
Luton North
Luton South
Maldon
Mid Bedfordshire
Mid Norfolk
North East Bedfordshire
North East Cambridgeshire
North East Hertfordshire
North Norfolk
North West Cambridgeshire
North West Norfolk
Norwich North
Norwich South
Peterborough
Rayleigh and Wickford
Rochford and Southend East
Saffron Walden
South Basildon and East Thurrock
South Cambridgeshire
South East Cambridgeshire
South Norfolk
South Suffolk
South West Bedfordshire
South West Hertfordshire
South West Norfolk
Southend West
St Albans
Stevenage
Suffolk Coastal
Thurrock
Watford
Waveney
Welwyn Hatfield
West Suffolk
Witham
Barking
Battersea
Beckenham
Bermondsey and Old Southwark
Bethnal Green and Bow
Bexleyheath and Crayford
Brent Central
Brent North
Brentford and Isleworth
Bromley and Chislehurst
Camberwell and Peckham
Carshalton and Wallington
Chelsea and Fulham
Chingford and Woodford Green
Chipping Barnet
Cities of London and Westminster
Croydon Central
Croydon North
Croydon South
Dagenham and Rainham
Dulwich and West Norwood
Ealing Central and Acton
Ealing North
Ealing – Southall
East Ham
Edmonton
Eltham
Enfield North
Enfield – Southgate
Erith and Thamesmead
Feltham and Heston
Finchley and Golders Green
Greenwich and Woolwich
Hackney North and Stoke
Newington
Hackney South and Shoreditch
Hammersmith
Hampstead and Kilburn
Harrow East
Harrow West
Hayes and Harlington
Hendon
Holborn and St Pancras
Hornchurch and Upminster
Hornsey and Wood Green
Ilford North
Ilford South
Islington North
Islington South and Finsbury
Kensington
Kingston and Surbiton
Lewisham East
Lewisham West and Penge
Lewisham – Deptford
Leyton and Wanstead
Mitcham and Morden
Old Bexley and Sidcup
Orpington
Poplar and Limehouse
Putney
Richmond Park
Romford
Ruislip; Northwood and Pinner
Streatham
Sutton and Cheam
Tooting
Tottenham
Twickenham
Uxbridge and South Ruislip
Vauxhall
Walthamstow
West Ham
Westminster North
Wimbledon
Aldershot
Arundel and South Downs
Ashford
Aylesbury
Banbury
Basingstoke
Beaconsfield
Bexhill and Battle
Bognor Regis and Littlehampton
Bracknell
Brighton – Kemptown
Brighton – Pavilion
Buckingham
Canterbury
Chatham and Aylesford
Chesham and Amersham
Chichester
Crawley
Dartford
Dover
East Hampshire
East Surrey
East Worthing and Shoreham
Eastbourne
Eastleigh
Epsom and Ewell
Esher and Walton
Fareham
Faversham and Mid Kent
Folkestone and Hythe
Gillingham and Rainham
Gosport
Gravesham
Guildford
Hastings and Rye
Havant
Henley
Horsham
Hove
Isle of Wight
Lewes
Maidenhead
Maidstone and The Weald
Meon Valley
Mid Sussex
Milton Keynes North
Milton Keynes South
Mole Valley
New Forest East
New Forest West
Newbury
North East Hampshire
North Thanet
North West Hampshire
Oxford East
Oxford West and Abingdon
Portsmouth North
Portsmouth South
Reading East
Reading West
Reigate
Rochester and Strood
Romsey and Southampton North
Runnymede and Weybridge
Sevenoaks
Sittingbourne and Sheppey
Slough
South Thanet
South West Surrey
Southampton – Itchen
Southampton – Test
Spelthorne
Surrey Heath
Tonbridge and Malling
Tunbridge Wells
Wantage
Wealden
Winchester
Windsor
Witney
Woking
Wokingham
Worthing West
Wycombe
Bath
Bournemouth East
Bournemouth West
Bridgwater and West Somerset
Bristol East
Bristol North West
Bristol South
Bristol West
Camborne and Redruth
Central Devon
Cheltenham
Chippenham
Christchurch
Devizes
East Devon
Exeter
Filton and Bradley Stoke
Forest of Dean
Gloucester
Kingswood
Mid Dorset and North Poole
Newton Abbot
North Cornwall
North Devon
North Dorset
North East Somerset
North Somerset
North Swindon
North Wiltshire
Plymouth – Moor View
Plymouth – Sutton and Devonport
Poole
Salisbury
Somerton and Frome
South Dorset
South East Cornwall
South Swindon
South West Devon
South West Wiltshire
St Austell and Newquay
St Ives
Stroud
Taunton Deane
Tewkesbury
The Cotswolds
Thornbury and Yate
Tiverton and Honiton
Torbay
Torridge and West Devon
Totnes
Truro and Falmouth
Wells
West Dorset
Weston-Super-Mare
Yeovil
Aberavon
Aberconwy
Alyn and Deeside
Arfon
Blaenau Gwent
Brecon and Radnorshire
Bridgend
Caerphilly
Cardiff Central
Cardiff North
Cardiff South and Penarth
Cardiff West
Carmarthen East and Dinefwr
Carmarthen West and South
Pembrokeshire
Ceredigion
Clwyd South
Clwyd West
Cynon Valley
Delyn
Dwyfor Meirionnydd
Gower
Islwyn
Llanelli
Merthyr Tydfil and Rhymney
Monmouth
Montgomeryshire
Neath
Newport East
Newport West
Ogmore
Pontypridd
Preseli Pembrokeshire
Rhondda
Swansea East
Swansea West
Torfaen
Vale of Clwyd
Vale of Glamorgan
Wrexham
Ynys Môn
Aberdeen North
Aberdeen South
Airdrie and Shotts
Angus
Argyll and Bute
Ayr; Carrick and Cumnock
Banff and Buchan
Berwickshire; Roxburgh and
Selkirk
Caithness; Sutherland and Easter
Ross
Central Ayrshire
Coatbridge; Chryston and Bellshill
Cumbernauld; Kilsyth and
Kirkintilloch East
Dumfries and Galloway
Dumfriesshire; Clydesdale and
Tweeddale
Dundee East
Dundee West
Dunfermline and West Fife
East Dunbartonshire
East Kilbride; Strathaven and
Lesmahagow
East Lothian
East Renfrewshire
Edinburgh East
Edinburgh North and Leith
Edinburgh South
Edinburgh South West
Edinburgh West
Falkirk
Glasgow Central
Glasgow East
Glasgow North
Glasgow North East
Glasgow North West
Glasgow South
Glasgow South West
Glenrothes
Gordon
Inverclyde
Inverness; Nairn; Badenoch and
Strathspey
Kilmarnock and Loudoun
Kirkcaldy and Cowdenbeath
Lanark and Hamilton East
Linlithgow and East Falkirk
Livingston
Midlothian
Moray
Motherwell and Wishaw
Na h-Eileanan an Iar
North Ayrshire and Arran
North East Fife
Ochil and South Perthshire
Orkney and Shetland
Paisley and Renfrewshire North
Paisley and Renfrewshire South
Perth and North Perthshire
Ross; Skye and Lochaber
Rutherglen and Hamilton West
Stirling
West Aberdeenshire and
Kincardine
West Dunbartonshire
Belfast East
Belfast North
Belfast South
Belfast West
East Antrim
East Londonderry
Fermanagh and South Tyrone
Foyle
Lagan Valley
Mid Ulster
Newry and Armagh
North Antrim
North Down
South Antrim
South Down
Strangford
Upper Bann
West Tyrone
To view this licence, go
or write to the Informatio
Analysis showing the count, employment and turnover of VAT and/or PAYE based enterprises in Parliamentary Constituencies of the United Kingd
Data as at March 2016
Note: All figures are rounded to avoid disclosure. Values may be rounded down to zero and so all zeros are not necessarily true zeros.
Count
Employment
Turnover (£’000s)
40
114
£5,560.00
30
117
£4,934.00
30
137
£9,543.00
10
61
£3,425.00
30
67
£4,400.00
30
137
£7,944.00
15
2,364
£208,085.00
25
60
£4,933.00
20
73
£3,808.00
45
177
£10,189.00
10
360
£66,685.00
15
892
£145,096.00
40
344
£41,663.00
25
137
£21,364.00
55
199
£12,493.00
35
197
£13,107.00
30
97
£6,197.00
20
150
£5,916.00
25
76
£6,688.00
30
122
£5,134.00
15
139
£12,250.00
20
149
£12,015.00
20
245
£10,343.00
20
65
£3,140.00
25
600
£42,339.00
35
213
£10,164.00
35
341
£38,204.00
15
42
£1,635.00
15
114
£9,041.00
65
226
£17,416.00
50
449
£36,570.00
40
146
£8,673.00
35
147
£27,547.00
60
580
£21,892.00
130
702
£77,770.00
30
115
£7,251.00
35
221
£11,788.00
60
327
£30,488.00
50
548
£53,577.00
45
194
£14,640.00
40
184
£10,865.00
35
203
£14,360.00
55
552
£125,278.00
70
691
£44,703.00
30
336
£26,085.00
55
1,447
£509,905.00
50
323
£35,360.00
60
189
£16,006.00
60
346
£21,680.00
35
89
£4,588.00
50
738
£54,134.00
35
579
£53,418.00
55
129
£8,889.00
25
66
£3,796.00
50
231
£12,197.00
35
113
£7,460.00
20
80
£4,047.00
45
192
£13,608.00
45
915
£150,607.00
40
736
£129,310.00
35
224
£16,092.00
40
150
£6,974.00
25
136
£9,117.00
90
532
£48,408.00
25
63
£3,861.00
25
74
£3,735.00
15
38
£2,420.00
80
312
£39,663.00
10
26
£1,724.00
280
2,121
£269,142.00
50
133
£8,898.00
60
126
£16,765.00
30
161
£9,186.00
55
670
£69,673.00
50
283
£18,306.00
55
711
£78,628.00
45
171
£7,493.00
45
554
£53,267.00
80
330
£19,058.00
90
2,221
£204,150.00
65
1,038
£99,740.00
55
231
£16,286.00
30
88
£4,834.00
30
107
£6,182.00
40
121
£7,006.00
15
75
£6,511.00
20
360
£21,971.00
55
590
£56,704.00
60
760
£98,701.00
45
375
£81,544.00
95
248
£28,552.00
25
44
£2,907.00
30
585
£85,847.00
40
199
£10,606.00
30
161
£16,715.00
40
16,611
£1,190,417.00
85
596
£45,671.00
40
755
£116,557.00
25
212
£18,565.00
30
78
£6,001.00
30
125
£9,474.00
20
106
£8,526.00
50
380
£26,290.00
30
177
£16,865.00
30
120
£7,813.00
15
40
£1,904.00
60
1,146
£100,740.00
35
124
£8,787.00
65
989
£87,600.00
25
302
£28,329.00
75
325
£18,744.00
30
99
£4,377.00
105
422
£39,855.00
45
152
£10,138.00
80
892
£98,842.00
85
6,020
£565,201.00
30
113
£6,119.00
45
162
£10,216.00
15
54
£2,114.00
45
173
£8,747.00
55
253
£26,428.00
30
146
£18,116.00
45
479
£43,380.00
25
85
£7,076.00
110
379
£31,275.00
20
113
£8,927.00
75
887
£75,826.00
65
666
£60,163.00
20
77
£3,518.00
15
95
£20,738.00
50
236
£27,505.00
100
27,695
£2,666,358.00
25
207
£5,977.00
60
604
£41,096.00
35
180
£17,935.00
35
302
£32,890.00
30
138
£13,760.00
35
180
£8,064.00
30
114
£6,918.00
50
636
£59,656.00
70
209
£17,021.00
20
66
£4,134.00
25
91
£3,711.00
50
172
£20,904.00
20
82
£7,464.00
45
160
£32,544.00
90
293
£20,775.00
25
266
£13,752.00
10
82
£5,166.00
30
49
£3,658.00
25
68
£3,761.00
60
274
£13,988.00
75
355
£26,963.00
65
1,577
£125,098.00
60
953
£85,238.00
25
50
£3,088.00
55
180
£10,687.00
30
1,437
£103,756.00
40
1,472
£259,565.00
40
481
£89,869.00
25
122
£7,523.00
30
2,905
£253,578.00
45
612
£57,594.00
95
910
£74,874.00
25
167
£26,792.00
60
346
£42,908.00
40
224
£21,205.00
45
296
£15,392.00
65
507
£50,645.00
35
256
£19,868.00
55
374
£18,685.00
80
786
£46,751.00
80
1,199
£95,760.00
30
69
£3,226.00
40
2,133
£308,346.00
70
778
£34,941.00
100
2,762
£257,467.00
60
257
£21,715.00
50
461
£58,516.00
320
7,616
£419,263.00
215
2,343
£130,136.00
90
844
£76,533.00
50
277
£17,366.00
65
350
£38,319.00
55
296
£18,989.00
35
161
£8,588.00
25
59
£3,318.00
70
348
£47,622.00
25
61
£2,576.00
60
2,542
£130,442.00
35
697
£60,656.00
55
1,520
£132,806.00
60
177
£9,132.00
25
278
£27,742.00
65
1,891
£406,136.00
70
395
£65,335.00
110
398
£46,042.00
30
1,440
£279,886.00
45
189
£13,057.00
30
131
£12,579.00
35
101
£4,608.00
50
43,209
£4,075,294.00
70
174
£24,769.00
60
1,236
£121,352.00
25
153
£9,352.00
25
50
£3,230.00
15
866
£47,480.00
90
372
£23,413.00
45
136
£9,742.00
225
1,170
£100,988.00
15
49
£2,796.00
50
172
£8,565.00
20
55
£2,667.00
25
85
£5,034.00
35
75
£4,774.00
35
122
£6,787.00
30
171
£11,138.00
45
190
£16,580.00
20
50
£8,150.00
55
674
£40,942.00
20
105
£4,590.00
20
279
£27,201.00
35
225
£10,569.00
60
256
£14,471.00
55
165
£12,102.00
50
267
£26,245.00
75
230
£16,951.00
40
110
£10,718.00
45
182
£21,217.00
35
162
£8,136.00
70
234
£21,464.00
50
136
£9,195.00
20
46
£4,252.00
30
165
£26,010.00
25
142
£9,868.00
35
4,175
£355,081.00
75
276
£18,774.00
40
370
£39,712.00
25
66
£3,601.00
40
140
£9,761.00
35
243
£28,749.00
25
136
£8,421.00
20
171
£11,292.00
10
17
£896.00
30
124
£12,639.00
35
125
£6,012.00
100
256
£17,925.00
30
99
£6,446.00
30
162
£11,593.00
25
127
£6,346.00
30
74
£5,022.00
35
381
£41,274.00
60
544
£24,752.00
45
305
£19,284.00
75
1,005
£66,032.00
25
176
£10,442.00
20
107
£19,652.00
60
215
£14,498.00
15
37
£2,678.00
45
332
£20,426.00
55
573
£25,887.00
50
154
£9,871.00
45
1,168
£141,914.00
30
155
£19,385.00
50
169
£11,722.00
55
158
£10,608.00
85
199
£14,182.00
50
194
£11,571.00
50
226
£17,354.00
70
280
£15,709.00
90
254
£18,100.00
30
620
£35,716.00
60
141
£13,972.00
40
140
£9,385.00
30
88
£7,630.00
45
153
£13,286.00
100
311
£29,225.00
35
183
£8,898.00
50
691
£47,795.00
50
139
£7,582.00
55
542
£51,716.00
90
224
£20,812.00
135
732
£173,592.00
100
327
£24,491.00
55
392
£119,386.00
45
311
£14,774.00
15
119
£16,689.00
50
319
£22,249.00
45
304
£42,025.00
50
138
£11,614.00
45
135
£7,309.00
55
116
£12,740.00
35
193
£12,260.00
90
225
£15,807.00
80
279
£18,557.00
35
926
£52,437.00
45
1,096
£98,343.00
30
250
£19,431.00
75
422
£29,416.00
40
249
£12,208.00
55
169
£13,008.00
65
244
£14,659.00
95
258
£21,891.00
20
65
£3,576.00
70
160
£13,198.00
75
393
£19,249.00
55
156
£9,863.00
80
668
£43,767.00
50
125
£8,097.00
130
328
£24,722.00
40
236
£16,224.00
70
163
£9,283.00
100
591
£76,427.00
35
275
£31,495.00
90
301
£19,694.00
40
245
£16,440.00
75
17,997
£2,305,750.00
20
60
£3,297.00
65
260
£45,383.00
55
281
£15,722.00
55
373
£55,791.00
35
138
£9,674.00
240
2,457
£327,636.00
70
160
£9,398.00
220
1,094
£217,167.00
410
3,273
£387,535.00
15
43
£2,741.00
120
979
£113,217.00
90
9,895
£959,631.00
190
2,270
£225,921.00
90
1,198
£138,145.00
165
392
£69,647.00
45
129
£8,995.00
360
3,342
£363,266.00
70
150
£10,075.00
155
300
£28,352.00
1,435
100,335
£12,931,350.00
60
209
£11,094.00
70
203
£16,595.00
80
188
£30,736.00
25
86
£6,309.00
195
361
£28,271.00
205
9,916
£1,047,176.00
70
183
£28,265.00
120
297
£19,082.00
85
408
£21,244.00
85
676
£43,283.00
50
97
£5,560.00
55
357
£54,271.00
110
210
£34,775.00
20
54
£4,089.00
20
37
£1,743.00
235
1,879
£102,922.00
95
284
£21,369.00
290
635
£50,784.00
480
2,968
£297,731.00
250
718
£77,937.00
405
737
£87,642.00
75
334
£46,503.00
55
117
£7,100.00
20
49
£7,174.00
115
239
£25,989.00
695
12,941
£2,076,824.00
35
173
£10,938.00
390
1,058
£108,126.00
60
208
£11,244.00
85
317
£29,268.00
270
736
£74,077.00
375
5,800
£863,067.00
470
7,992
£875,350.00
90
216
£16,811.00
65
151
£9,292.00
115
197
£11,270.00
140
278
£20,851.00
80
219
£30,594.00
50
206
£14,684.00
35
225
£12,888.00
45
106
£7,050.00
110
601
£34,096.00
135
207
£24,683.00
300
1,369
£148,798.00
40
277
£30,931.00
80
168
£13,562.00
135
611
£108,623.00
55
134
£6,986.00
185
1,793
£108,040.00
165
1,072
£194,528.00
170
420
£46,307.00
40
227
£17,541.00
180
2,526
£193,133.00
120
1,802
£140,566.00
125
493
£26,826.00
230
2,791
£274,397.00
140
367
£34,341.00
35
128
£5,769.00
100
256
£17,701.00
75
210
£17,796.00
60
167
£10,989.00
70
156
£11,684.00
30
61
£4,196.00
115
375
£34,649.00
75
182
£12,330.00
30
101
£7,996.00
25
72
£4,847.00
80
135
£7,897.00
260
807
£65,028.00
85
231
£19,899.00
65
182
£11,051.00
15
72
£7,898.00
120
423
£38,313.00
120
641
£53,493.00
20
90
£15,090.00
30
97
£4,968.00
35
65
£3,927.00
75
209
£14,124.00
90
1,457
£138,308.00
40
108
£10,330.00
60
1,501
£117,672.00
30
87
£5,159.00
55
160
£9,710.00
150
432
£31,582.00
40
142
£9,416.00
45
125
£7,310.00
50
119
£7,256.00
20
50
£5,192.00
35
158
£16,137.00
25
57
£4,259.00
90
283
£45,264.00
80
165
£8,428.00
20
2,865
£202,123.00
120
362
£25,299.00
70
296
£31,380.00
150
356
£23,909.00
75
299
£14,004.00
115
239
£16,067.00
80
220
£19,162.00
55
240
£18,844.00
45
525
£53,171.00
80
1,068
£266,110.00
50
553
£43,114.00
55
222
£15,934.00
105
235
£23,744.00
40
120
£6,678.00
75
256
£14,415.00
75
203
£14,098.00
45
105
£16,089.00
40
101
£5,911.00
55
162
£20,554.00
80
327
£24,459.00
85
195
£16,488.00
25
67
£2,916.00
35
109
£6,623.00
50
236
£22,762.00
20
81
£9,719.00
75
203
£15,623.00
50
168
£9,584.00
35
548
£76,694.00
70
146
£13,421.00
90
241
£15,290.00
25
75
£3,682.00
55
188
£79,369.00
45
230
£25,170.00
130
381
£33,298.00
20
157
£10,932.00
25
107
£6,663.00
35
268
£24,859.00
60
136
£9,341.00
65
132
£10,809.00
115
306
£19,001.00
60
137
£9,578.00
100
255
£18,786.00
80
236
£14,663.00
80
205
£20,528.00
130
5,290
£552,358.00
55
166
£14,928.00
35
142
£6,351.00
40
190
£11,985.00
60
807
£67,171.00
120
283
£17,193.00
40
114
£7,132.00
55
201
£13,911.00
40
211
£19,169.00
35
112
£6,539.00
30
65
£6,626.00
40
238
£22,364.00
175
602
£47,707.00
30
102
£5,966.00
70
260
£15,539.00
85
273
£19,349.00
60
155
£9,527.00
40
113
£5,805.00
70
199
£10,738.00
55
200
£8,408.00
55
366
£26,643.00
25
210
£19,475.00
35
82
£3,500.00
40
301
£36,016.00
20
77
£4,373.00
35
176
£16,146.00
30
130
£5,581.00
75
435
£24,120.00
60
335
£22,789.00
70
199
£13,378.00
50
175
£21,537.00
55
173
£14,447.00
35
273
£65,994.00
55
423
£26,009.00
15
32
£2,475.00
45
153
£7,078.00
55
165
£11,895.00
65
178
£16,790.00
100
275
£21,719.00
55
16,085
£1,235,264.00
45
154
£9,433.00
30
72
£4,494.00
35
100
£6,364.00
60
185
£14,877.00
50
211
£15,034.00
85
866
£46,123.00
95
503
£69,107.00
65
295
£19,188.00
40
2,627
£229,399.00
130
383
£33,736.00
30
157
£13,861.00
70
1,058
£88,502.00
50
203
£10,148.00
50
119
£7,269.00
90
367
£25,774.00
80
382
£16,157.00
95
13,125
£810,882.00
105
873
£74,334.00
35
107
£4,634.00
40
385
£43,026.00
20
83
£3,004.00
35
174
£10,061.00
20
103
£9,335.00
30
90
£5,119.00
20
156
£11,257.00
55
147
£7,408.00
30
138
£7,595.00
20
89
£6,835.00
50
222
£15,416.00
40
86
£5,360.00
50
8,582
£360,567.00
50
151
£8,318.00
30
68
£3,627.00
50
205
£9,794.00
40
118
£4,733.00
25
85
£3,086.00
35
139
£4,660.00
10
24
£1,392.00
20
111
£7,310.00
45
145
£7,328.00
35
104
£4,385.00
20
428
£64,608.00
20
85
£4,059.00
15
91
£2,295.00
65
251
£14,946.00
35
305
£27,188.00
20
65
£3,152.00
20
675
£45,262.00
25
84
£4,685.00
15
480
£46,174.00
25
114
£7,855.00
40
155
£8,268.00
15
101
£5,360.00
15
224
£14,353.00
45
158
£11,838.00
5
45
£2,856.00
25
131
£5,061.00
40
92
£6,085.00
30
605
£74,025.00
30
99
£4,511.00
25
219
£13,453.00
40
282
£27,976.00
20
159
£14,448.00
40
789
£87,908.00
50
197
£9,818.00
45
378
£27,707.00
45
230
£16,361.00
65
1,247
£71,630.00
25
85
£3,912.00
25
89
£7,054.00
15
165
£8,863.00
20
254
£13,384.00
35
132
£6,688.00
40
4,594
£241,456.00
25
104
£5,319.00
35
395
£61,865.00
30
81
£4,260.00
45
147
£8,559.00
35
123
£7,342.00
35
114
£14,057.00
55
236
£12,970.00
60
382
£25,775.00
105
441
£24,670.00
55
225
£36,633.00
30
109
£5,794.00
25
75
£5,123.00
45
170
£8,880.00
140
2,008
£171,699.00
20
151
£9,990.00
65
198
£15,818.00
15
39
£2,503.00
25
47
£2,624.00
40
82
£5,598.00
15
32
£1,462.00
10
75
£3,590.00
25
84
£5,598.00
20
42
£2,535.00
40
221
£13,282.00
45
410
£28,550.00
25
354
£27,244.00
35
172
£9,001.00
35
93
£5,592.00
15
4,343
£385,408.00
15
55
£3,485.00
30
1,042
£63,354.00
20
116
£4,377.00
45
210
£16,180.00
35
147
£17,146.00
25
159
£12,835.00
45
365
£31,952.00
30
181
£8,132.00
25
3,992
£240,428.00
30
235
£121,648.00
55
481
£38,452.00
30
85
£4,019.00
25
84
£3,796.00
60
268
£18,671.00
35
120
£5,942.00
10
23
£840.00
40
228
£12,266.00
25
188
£14,686.00
75
279
£27,432.00
25
31,205
£2,796,099.00
35
128
£8,687.00
45
277
£16,848.00
70
835
£49,616.00
35
240
£10,860.00
55
253
£21,644.00
50
384
£23,701.00
75
319
£21,376.00
50
424
£33,931.00
35
291
£49,428.00
30
126
£12,146.00
40
151
£7,983.00
50
249
£19,180.00
75
1,214
£100,160.00
45
659
£42,684.00
This table is confidentialised by Tau Argus
Extract
paent16
Date
01 September 2017
Das Number
AH088
Please note
– the tables contained in this spreadsheet may not be suitable for all analytical
purposes as they were produced in response to an ad hoc request on 31/08/2017 and are based on a customer specified ind
National Statistics for individual themes are published by a variety of government departments, based on a variety of
data sources such as surveys and administrative information. Details of the source of information on which the statistics are based will be included in the pub
A list of publications can be found at: https://www.ons.gov.uk/releasecalendar
For further information please contact:
IDBRDAS@ons.gov.uk
Tel: 01633 456902
Created on 01/09/2017 by the Office for National Statistics.
© Crown
copyright.
You may reuse this
information
(not including
logos) free of
charge in any
format or
medium,
under the
terms of the
Open
Government
Licence.
To view this licence, go to: http://www.nationalarchives.gov.uk/doc/open-government-licence/
or write to the Information Policy Team, The National Archives, Kew, London TW9 4DU. Email: psi@nationalarchives.gsi.gov.uk
ses in Parliamentary Constituencies of the United Kingdom for the Fashion Industry
d so all zeros are not necessarily true zeros.
Average (=Average)
Min (=Min)
Employment
906
17
Turnover (‘000s)
90,482
840
No. of Employees > 100
546
Search term*
Count
County
*enter county you
wish to search for in
cell G40
Employment
EXAMPLE
Search term*
Blackburn
Count
Turnover (£’000s)
County
Blackburn
*enter county you
wish to search for in
cell M40
60
Employment
Turnover (£’000s)
580
21892
ANSWERS
MUST BE
DONE ON
THIS
WORKSHEET
Item
number
a
b
c
d
e
f
Instructions
This exercise is about using LOOKUP functions
as a search tool that will enable you to locate
information relating to identified counties. Use
the table on the right to fill these figures.
Enter appropiate formulas for part a) below in
identifying data for a particular county uniquely
from the cells in the Table F11 to I661
Create a VLOOKUP of search term in Cell L17 to
check Count and Employment and Turnover using
cells in the Table F11 to I661 and write these built
in Excel functions in cells M21 and N21
respectively and replace the question marks)
Change to tab color of this worksheet to, Orange,
Accent 2, Darket 50%
Save this Excel Workbook with the new name
Formative Excel Exam 20-21
In the document properties add “LCF” as
company
Please set following page margins for this
worksheet:
Left = “1”
Right = “4”
Top = “0.75”
Bottom = “0.75”
Insert a line Sparklines into cell E13 that references
the data in cells I12:I661
Total
Marks
Allocated
20
2
2
3
5
5
37
Sparkline
IDBRDAS@ons.gov.uk
Tel: 01633 456902
Created on 01/09/2017 by the Office for National Statistics.
To view this licence, go to: http://www.nationalarchives.gov.uk/
or write to the Information Policy Team, The National Archives,
Turnover
IDBRDAS@ons.gov.uk
Tel: 01633 456902
Created on 01/09/2017 by the Office for National Statistics.
To view this licence, go to: http://www.nationalarchives.gov.uk/doc/open-government-licence/
or write to the Information Policy Team, The National Archives, Kew, London TW9 4DU. Email: psi@nationalarchives
County
Berwick-upon-Tweed
Bishop Auckland
Blaydon
Blyth Valley
City of Durham
Darlington
Easington
Gateshead
Hartlepool
Hexham
Houghton and Sunderland South
Jarrow
Middlesbrough
Middlesbrough South and East Cleveland
Newcastle upon Tyne Central
Newcastle upon Tyne East
Newcastle upon Tyne North
North Durham
North Tyneside
North West Durham
Redcar
Sedgefield
South Shields
Stockton North
Stockton South
Sunderland Central
Tynemouth
Wansbeck
Washington and Sunderland West
Altrincham and Sale West
Ashton-under-Lyne
Barrow and Furness
Birkenhead
Blackburn
Blackley and Broughton
Blackpool North and Cleveleys
Blackpool South
Bolton North East
Bolton South East
Bolton West
Bootle
Burnley
Bury North
Bury South
Carlisle
Cheadle
Chorley
City of Chester
Congleton
Copeland
Crewe and Nantwich
Denton and Reddish
Eddisbury
Ellesmere Port and Neston
Fylde
Garston and Halewood
Halton
Hazel Grove
Heywood and Middleton
Hyndburn
Knowsley
Lancaster and Fleetwood
Leigh
Liverpool – Riverside
Liverpool – Walton
Liverpool – Wavertree
Liverpool – West Derby
Macclesfield
Makerfield
Manchester Central
Manchester – Gorton
Manchester – Withington
Morecambe and Lunesdale
Oldham East and Saddleworth
Oldham West and Royton
Pendle
Penrith and The Border
Preston
Ribble Valley
Rochdale
Rossendale and Darwen
Salford and Eccles
Sefton Central
South Ribble
Southport
St Helens North
St Helens South and Whiston
Stalybridge and Hyde
Stockport
Stretford and Urmston
Tatton
Wallasey
Warrington North
Warrington South
Weaver Vale
West Lancashire
Westmorland and Lonsdale
Wigan
Wirral South
Wirral West
Workington
Worsley and Eccles South
Wyre and Preston North
Wythenshawe and Sale East
Barnsley Central
Barnsley East
Batley and Spen
Beverley and Holderness
Bradford East
Bradford South
Bradford West
Brigg and Goole
Calder Valley
Cleethorpes
Colne Valley
Dewsbury
Don Valley
Doncaster Central
Doncaster North
East Yorkshire
Elmet and Rothwell
Great Grimsby
Halifax
Haltemprice and Howden
Harrogate and Knaresborough
Hemsworth
Huddersfield
Keighley
Kingston upon Hull East
Kingston upon Hull North
Kingston upon Hull West and Hessle
Leeds Central
Leeds East
Leeds North East
Leeds North West
Leeds West
Morley and Outwood
Normanton; Pontefract and Castleford
Penistone and Stocksbridge
Pudsey
Richmond (Yorks)
Rother Valley
Rotherham
Scarborough and Whitby
Scunthorpe
Selby and Ainsty
Sheffield Central
Sheffield South East
Sheffield – Brightside and Hillsborough
Sheffield – Hallam
Sheffield – Heeley
Shipley
Skipton and Ripon
Thirsk and Malton
Wakefield
Wentworth and Dearne
York Central
York Outer
Amber Valley
Ashfield
Bassetlaw
Bolsover
Boston and Skegness
Bosworth
Broxtowe
Charnwood
Chesterfield
Corby
Daventry
Derby North
Derby South
Derbyshire Dales
Erewash
Gainsborough
Gedling
Grantham and Stamford
Harborough
High Peak
Kettering
Leicester East
Leicester South
Leicester West
Lincoln
Loughborough
Louth and Horncastle
Mansfield
Mid Derbyshire
Newark
North East Derbyshire
North West Leicestershire
Northampton North
Northampton South
Nottingham East
Nottingham North
Nottingham South
Rushcliffe
Rutland and Melton
Sherwood
Sleaford and North Hykeham
South Derbyshire
South Holland and The Deepings
South Leicestershire
South Northamptonshire
Wellingborough
Aldridge-Brownhills
Birmingham – Edgbaston
Birmingham – Erdington
Birmingham – Hall Green
Birmingham – Hodge Hill
Birmingham – Ladywood
Birmingham – Northfield
Birmingham – Perry Barr
Birmingham – Selly Oak
Birmingham – Yardley
Bromsgrove
Burton
Cannock Chase
Coventry North East
Coventry North West
Coventry South
Dudley North
Dudley South
Halesowen and Rowley Regis
Hereford and South Herefordshire
Kenilworth and Southam
Lichfield
Ludlow
Meriden
Mid Worcestershire
Newcastle-under-Lyme
North Herefordshire
North Shropshire
North Warwickshire
Nuneaton
Redditch
Rugby
Shrewsbury and Atcham
Solihull
South Staffordshire
Stafford
Staffordshire Moorlands
Stoke-on-Trent Central
Stoke-on-Trent North
Stoke-on-Trent South
Stone
Stourbridge
Stratford-on-Avon
Sutton Coldfield
Tamworth
Telford
The Wrekin
Walsall North
Walsall South
Warley
Warwick and Leamington
West Bromwich East
West Bromwich West
West Worcestershire
Wolverhampto