Player Name Player No Run Scored Wicket Taken
Rahul Dravid 19 8479 2
Rohit Sharma 12 12537 5
Virat Kohli 14 12062 45
Zaheer Khan 25 13713 120
Harbhajan Singh 34 6432 125
MS DHONI 7 10643 4
To Find:
Player Name Run Scored
ms dhoni 10643
CustomerID CompanyName ContactName ContactTitle City
ALFKI Alfreds Futterkiste Maria Anders Sales Representative Berlin
ANATR Ana Trujillo Emparedados y helados Ana Trujillo Owner México D.F.
ANTON Antonio Moreno Taquería Antonio Moreno Owner México D.F.
AROUT Around the Horn Thomas Hardy Sales Representative London
BERGS Berglunds snabbköp Christina Berglund Order Administrator Luleå
BLAUS Blauer See Delikatessen Hanna Moos Sales Representative Mannheim
BLONP Blondel père et fils Frédérique Citeaux Marketing Manager Strasbourg
BOLID Bólido Comidas preparadas Martín Sommer Owner Madrid
BONAP Bon app' Laurence Lebihan Owner Marseille
BOTTM Bottom-Dollar Markets Elizabeth Lincoln Accounting Manager Tsawassen
BSBEV B's Beverages Victoria Ashworth Sales Representative London
CACTU Cactus Comidas para llevar Patricio Simpson Sales Agent Buenos Aires
CENTC Centro comercial Moctezuma Francisco Chang Marketing Manager México D.F.
CHOPS Chop-suey Chinese Yang Wang Owner Bern
COMMI Comércio Mineiro Pedro Afonso Sales Associate São Paulo
CONSH Consolidated Holdings Elizabeth Brown Sales Representative London
DRACD Drachenblut Delikatessen Sven Ottlieb Order Administrator Aachen
DUMON Du monde entier Janine Labrune Owner Nantes
EASTC Eastern Connection Ann Devon Sales Agent London
ERNSH Ernst Handel Roland Mendel Sales Manager Graz
FAMIA Familia Arquibaldo Aria Cruz Marketing Assistant São Paulo
FISSA FISSA Fabrica Inter. Salchichas S.A. Diego Roel Accounting Manager Madrid
FOLIG Folies gourmandes Martine Rancé Assistant Sales Agent Lille
FOLKO Folk och fä HB Maria Larsson Owner Bräcke
FRANK Frankenversand Peter Franken Marketing Manager München
FRANR France restauration Carine Schmitt Marketing Manager Nantes
FRANS Franchi S.p.A. Paolo Accorti Sales Representative Torino
FURIB Furia Bacalhau e Frutos do Mar Lino Rodriguez Sales Manager Lisboa
GALED Galería del gastrónomo Eduardo Saavedra Marketing Manager Barcelona
GODOS Godos Cocina Típica José Pedro Freyre Sales Manager Sevilla
Country Phone
Germany 030-0074321 Task: To find the country and phone no. of the contact names giv
Mexico (5) 555-4729
Mexico (5) 555-3932 S.No. Contact Name Country Phone No.
UK (171) 555-7788 1 Francisco Chang Mexico 88.60.15.31
Sweden 0921-12 34 65 2 Martín Sommer Spain (5) 555-4729
Germany 0621-08460 3 Eduardo Saavedra Spain (11) 555-7647
France 88.60.15.31 4 Elizabeth Brown UK (171) 555-7788
Spain (91) 555 22 82 5 Sven Ottlieb Germany 0921-12 34 65
France 91.24.45.40
Canada (604) 555-4729
UK (171) 555-1212
Argentina (1) 135-5555
Mexico (5) 555-3392
Switzerland 0452-076545
Brazil (11) 555-7647
UK (171) 555-2282
Germany 0241-039123
France 40.67.88.88
UK (171) 555-0297
Austria 7675-3425
Brazil (11) 555-9857
Spain (91) 555 94 44
France 20.16.10.16
Sweden 0695-34 67 21
Germany 089-0877310
France 40.32.21.21
Italy 011-4988260
Portugal (1) 354-2534
Spain (93) 203 4560
Spain (95) 555 82 82
one no. of the contact names given below from the data
Phone No.
88.60.15.31
(5) 555-4729
(11) 555-7647
(171) 555-7788
0921-12 34 65
Dog
Size to
Dog Name Neck in
Order
cm
Scooby Doo 20 S Neck Size Jacket Size
Petra 22 S 0 XXS
Lassie 19 XS 10 XS
Snoopy 13 XS 20 S
Beethoven 44 M 40 M
Benji 27 S 60 L
Eddie 21 S 80 XL
Rin Tin Tin 14 XS 100 XXL
Toto 15 XS
Hooch 38 S
Santa's Little Helper 15 XS
Shep 19 XS
Marley 25 S
Cliffford (The Big Red Dog) 200 XXL
Task: Fill in the empty columns with reference to the data table given below
Data
Code C130 C131 C132 C133 C134 C135
Product Product A Product B Product C Product D Product E Product F
Colour Blue White Red White Green Blue
Price £24.95 £24.95 £24.95 £11.50 £11.50 £11.50
Stock Level 10 0 14 16 25 18
Stock Value £249.50 £0.00 £349.30 £184.00 £287.50 £207.00
To Find:
Product Price Stock Level
Product A
Product C
Product F
Task 1: Fill in the position with reference to the shipping data given
Customer Name Order Priority
Patrick Jones High
Alex Russell High
Tamara Dahlen Critical
Susan Vittorini High
Muhammed Yedwab Critical
Task 2: Return the item with reference to the data table given below
Customer Name Order Priority
Patrick Jones High
Alex Russell High
Tamara Dahlen Critical
Susan Vittorini High
Muhammed Yedwab Critical
Task 3: Answer the questions pertaining to sales data using Index and Match function
Months East Division West Division North Division
Jan 1975 1124 1463
Feb 1203 1412 985
Mar 1245 1209 1628
Apr 648 1842 605
May 1400 1558 1211
Jun 1597 1070 1635
Jul 1341 1793 1719
Aug 809 1365 746
Sep 1443 1747 1180
Oct 1018 1914 658
Nov 1336 1852 1764
Dec 1662 863 1500
Q1- Find the Sales for :
Division Month
South Division Jun
Task 4: Answer the question using Index and Match function
Violet Indigo Blue
Umbrella $4.00 $5.00 $10.50
Boots $6.00 $7.00 $14.00
Raincoat $5.00 $5.00 $7.00
Gloves $12.00 $11.00 $10.00
Ski Jacket $22.00 $25.00 $20.00
Item Colour Price
Ski Jacket red
Raincoat orange
Umbrella violet
o the shipping data given
Alex Russell
he data table given below
Alex Russell
ta using Index and Match function
South Division
1839
1218
1574
1858
1618
969
1350
614
1218
751
963
1522
x and Match function
Green Yellow Orange Red
$8.50 $9.50 $5.50 $6.50
$5.00 $12.50 $11.50 $10.00
$5.00 $18.00 $7.00 $6.00
$5.00 $12.00 $10.00 $10.00
$15.00 $14.00 $12.00 $16.00
Shipping Data
Order No Order Date Customer Name Customer Type Account Manager
5014-1 2/11/2013 Patrick Jones Home Office Yvette Biti
5016-1 2/11/2013 Alex Russell Home Office Connor Betts
5018-1 2/12/2013 Tamara Dahlen Corporate Leighton Forrest
5019-1 2/13/2013 Susan Vittorini Home Office Yvette Biti
5020-1 2/14/2013 Muhammed Yedwab Consumer Nicholas Fernandes
5022-1 2/15/2013 Jasper Cacioppo Home Office Radhya Staples
5023-1 2/17/2013 Olvera Toch Home Office Yvette Biti
5024-1 2/18/2013 Sean Wendt Corporate Phoebe Gour
5025-1 2/20/2013 Rick Reed Consumer Phoebe Gour
5027-1 2/22/2013 Toby Swindell Small Business Leighton Forrest
5029-1 2/23/2013 Giulietta Weimer Corporate Natasha Song
5030-1 2/24/2013 Sylvia Foulston Corporate Tina Carlton
5031-1 2/25/2013 Paul Prost Corporate Connor Betts
5033-1 2/25/2013 Katherine Ducich Corporate Samantha Chairs
5034-1 2/26/2013 Natalie Webber Corporate Phoebe Gour
5036-1 3/7/2013 Sean ODonnell Corporate Yvette Biti
5037-1 3/11/2013 Art Foster Home Office Stevie Bacata
Customer Name Order Date
Rick Reed
Art foster
Alex Russell
Order Priority Product Name Product Category
High Artisan Heavy-Duty Office Supplies
High DrawIt Pizazz Watercolor Pencils, 10-Color Set with Brush Office Supplies
Critical Message Book, One Form per Page Office Supplies
High Cando S750 Color Inkjet Printer Technology
Critical Steady EarthWrite Recycled Pencils, Medium Soft, #2 Office Supplies
Medium Artisan Reinforcements for Hole-Punch Pages Office Supplies
Low Pencils Office Supplies
Critical Multimedia Mailers Office Supplies
Critical Pizazz Dustless Chalk Sticks Office Supplies
Not Specified TypeRight Side-Opening Peel & Seel Expanding Envelopes Office Supplies
Not Specified Artisan Printable Repositionable Plastic Tabs Office Supplies
Medium Assorted Color Push Pins Office Supplies
Medium Security-Tint Envelopes Office Supplies
Medium TypeRight Side-Opening Peel & Seel Expanding Envelopes Office Supplies
High Artisan Arch Ring Binders Office Supplies
Critical OIC Thumb-Tacks Office Supplies
Critical Apex Elite Stainless Steel Scissors Office Supplies
