Row Labels Number of Customers

USA 90
France 32
United Kingdom 14
Canada 10
China 9
Germany 8
Australia 7
Brazil 6
Singapore 6
Mexico 6
New Zealand 6
Japan 5
South Africa 4
Portugal 4
Italy 4
Ireland 2
Philippines 1
Venezuela 1
Sweden 1
Czech Republic 1
Northern Ireland 1
Denmark 1
Colombia 1
Dominican Republic 1
Ukraine 1
Ecuador 1
Bermuda 1
Egypt 1
Costa Rica 1
Finland 1
Bahamas 1
Bangladesh 1
Chile 1
Barbados 1
Thailand 1
Greece 1
Aruba 1
Hungary 1
Netherlands 1
India 1
Nicaragua 1
Indonesia 1
Norway 1
Pakistan 1
Panama 1
Peru 1
Israel 1
Poland 1
Russia 1
Romania 1
Saint Lucia 1
Scotland 1
Saudi Arabia 1
Jamaica 1
Bolivia 1
Vietnam 1
Spain 1
Wales 1
Switzerland 1
(blank) 1
Turkey 1
Malaysia 1
United Arab Emirates 1
Belgium 1
British Virgin Islands 1
Mongolia 1
Austria 1
Nepal 1
Zimbabwe 1
Kenya 1
Argentina 1
Luxembourg 1
Grand Total 269
Row Labels Order Records
FedEx 629
Loomis 693
Parcel Post 605
Pickup 585
Purolator 595
UPS 577
Grand Total 3684
Sales Ratio Column Labels
Row Labels Accessory Bicycle Grand Total
2013 3.33% 4.81% 8.15%
2014 18.22% 50.41% 68.63%
2015 5.42% 17.80% 23.22%
Grand Total 26.98% 73.02% 100.00%
Row Labels Purple Revenue
Backpedal Cycle Shop $102.66
BBS Pty $102.66
Bicicletas de Montaña Cancun $102.66
Bicicletas Buenos Aires $1,664.70
Bikes and Trikes $1,498.24
Bikes, Bikes, and More Bikes $68.44
Biking's It Industries $102.66
City Cyclists $34.22
Cyclopath $34.22
Equator Cycle $832.35
Fahrkraft Räder $1,767.36
Has Been Bikes (consignment) $68.44
Island Bikes $790.73
Mountain Madmen Bicycles $102.66
Off the Mountain Biking $102.66
Our Wheels Follow Us Everywhere $102.66
Pedal Pusher Bikes Inc. $102.66
Pedals Inc. $273.76
Platou Sport $102.66
Psycho-Cycle $2,281.58
Rad Bikes $2,497.05
Road Runners Paradise $34.22
Rocky Roadsters $68.44
Rowdy Rims Company $68.44
Sports Alsace $1,664.70
The Great Bike Shop $68.44
Tyred Out $136.88
Vélos Basse Normandie $2,497.05
Wheels and Stuff $2,565.49
Wheels Inc. $239.54
Grand Total $20,078.23
30

25

20
20

15
15
14
13

11

10
9 9 9

5
4

0
5
 26

Brid
Buchanan
Callahan
Davolio
Dodsworth
Fuller
15 Hellstern
King
13 Leverling
Martin
11 Patterson
Peacock
9 Pereira
8 Smith
Suyama
6

5
Row Labels Monthly Running Sum for Quantity
Active Outdoors Crochet Glove 3
Active Outdoors Lycra Glove 2
Descent 6
Endorphin 1
Guardian Chain Lock 2
InFlux Crochet Glove 7
Mozzie 4
Rapel 2
Roadster Mini Mtn Saddle 1
Triumph Pro Helmet 5
Triumph Vertigo Helmet 6
Wheeler 3
Xtreme Anatomic Ladies Saddle 3
Xtreme Rhino Lock 3
Xtreme Titan Lock 3
Xtreme Wide MTB Saddle 3
Xtreme Youth Helmet 2
Grand Total 56
Row Labels Year to Date Sales Quarter to Date Sales
Timeline: Works in Excel 201
Argentina $1,664.70 $1,664.70 resize.
Aruba $5,879.70 $5,879.70
Australia $9,899.99 $9,899.99
Austria $2,328.50 $96.00
Bahamas $659.70 $659.70
Bangladesh $65.70 $65.70
Barbados $329.85 $329.85
Belgium $9,799.50 $6,839.40
Bermuda $5,879.70 $5,879.70
Bolivia $97.02 $97.02
Brazil $1,885.10 $1,885.10
British Virgin Islands $33.90 $33.90
Canada $58,426.00 $440.13
Chile $17.50 $17.50
China $12,526.50 $12,526.50
Colombia $27.00 $27.00
Costa Rica $2,497.05 $2,497.05
Czech Republic $329.85 $329.85
Denmark $46.50 $46.50
Dominican Republic $27.00 $27.00
Ecuador $33.90 $33.90
Egypt $5,219.55 $5,219.55
Finland $989.55 $989.55
France $696.85 $524.55
Germany $11,395.57 $8,024.25
Greece $8,819.55 $8,819.55
Hungary $33.90 $33.90
India $35.70 $35.70
Indonesia $2,699.55 $2,699.55
Ireland $116.20 $116.20
Israel $2,699.55 $2,699.55
Italy $16,359.57 $10,672.92
Jamaica $790.73 $790.73
Japan $862.15 $862.15
Kenya $2,939.85 $2,939.85
Luxembourg $959.70 $959.70
Malaysia $46.50 $46.50
Mexico $15,861.54 $15,861.54
Mongolia $46.50 $46.50
Nepal $33.00 $33.00
Netherlands $7,163.41 $173.06
New Zealand $329.85 $329.85
Nicaragua $40.50 $40.50
Northern Ireland $16.50 $16.50
Norway $6,494.04 $5,453.44
Pakistan $313.36 $313.36
Panama $41.90 $41.90
Peru $43.50 $43.50
Philippines $43.50 $43.50
Poland $15,728.35 $1,111.50
Portugal $18,678.58 $11,771.75
Romania $14.50 $14.50
Russia $989.55 $989.55
Saint Lucia $5,219.55 $5,219.55
Saudi Arabia $2,065.11 $2,065.11
Scotland $67.80 $67.80
Singapore $18,582.45 $18,582.45
South Africa $832.35 $832.35
Spain $19,782.07 $19,782.07
Sweden $4,962.75 $4,962.75
Switzerland $6,003.34 $4,130.29
Thailand $329.85 $329.85
Turkey $959.70 $959.70
Ukraine $1,664.70 $1,664.70
United Arab Emirates $41.90 $41.90
United Kingdom $8,136.56 $7,456.90
USA $771,234.43 $155,223.93
Venezuela $16.50 $16.50
Vietnam $14.50 $14.50
Wales $539.85 $539.85
Zimbabwe $101.70 $101.70
(blank) $5,879.70 $5,879.70
Grand Total $957,189.52 $211,918.12
eline: Works in Excel 2013 or higher. Do not move or
ze.
Row Labels Sum of Unit Price Order Records Average Cost
Argentina 832.35 1 $1,664.70
Aruba 19.95 1 $39.90
Australia 301.21 7 $83.01
Austria 3365.94 30 $195.10
Bahamas 329.85 1 $659.70
Bangladesh 21.9 1 $65.70
Barbados 329.85 1 $329.85
Belgium 14078.84 61 $487.67
Bermuda 19.95 1 $39.90
Bolivia 48.51 1 $97.02
Brazil 584.5 6 $164.18
British Virgin Islands 33.9 1 $33.90
Canada 33144.49 208 $356.53
Chile 17.5 1 $17.50
China 315.06 9 $70.51
Colombia 13.5 1 $27.00
Costa Rica 832.35 1 $2,497.05
Czech Republic 329.85 1 $329.85
Denmark 15.5 1 $46.50
Dominican Republic 13.5 1 $27.00
Ecuador 33.9 1 $33.90
Egypt 17.85 1 $53.55
Finland 329.85 1 $989.55
France 10630.23 66 $293.36
Germany 9525.14 59 $361.80
Greece 764.85 1 $2,294.55
Hungary 33.9 1 $33.90
India 11.9 1 $35.70
Indonesia 80.19 1 $240.57
Ireland 48.4 2 $58.10
Israel 899.85 1 $2,699.55
Italy 15912.77 95 $363.70
Jamaica 790.73 1 $790.73
Japan 110.25 5 $22.05
Kenya 145.87 1 $145.87
Luxembourg 112.2 1 $224.40
Malaysia 15.5 1 $46.50
Mexico 2722.79 6 $978.97
Mongolia 15.5 1 $46.50
Nepal 16.5 1 $33.00
Netherlands 9270.24 58 $366.62
New Zealand 652.19 6 $168.07
Nicaragua 13.5 1 $40.50
Northern Ireland 16.5 1 $16.50
Norway 7323.04 62 $208.06
Pakistan 313.36 1 $313.36
Panama 41.9 1 $41.90
Peru 14.5 1 $43.50
Philippines 14.5 1 $43.50
Poland 7869.98 62 $264.67
Portugal 9992.84 48 $443.26
Romania 14.5 1 $14.50
Russia 329.85 1 $989.55
Saint Lucia 62.45 1 $187.35
Saudi Arabia 688.37 1 $2,065.11
Scotland 33.9 1 $67.80
Singapore 522.01 6 $131.02
South Africa 1400 4 $486.91
Spain 11020.39 60 $382.74
Sweden 7493.46 50 $362.42
Switzerland 9927.55000000001 54 $337.02
Thailand 329.85 1 $329.85
Turkey 112.2 1 $224.40
Ukraine 832.35 1 $1,664.70
United Arab Emirates 41.9 1 $41.90
United Kingdom 7951.13 58 $294.13
USA 376903.060000001 2614 $295.14
Venezuela 16.5 1 $16.50
Vietnam 14.5 1 $14.50
Wales 539.85 1 $539.85
Zimbabwe 33.9 1 $101.70
(blank) 39.85 1 $79.70
Grand Total 550696.79 3684 $308.67