Player_ID Hockey Team Country Name Weight Height DOB
1 Women Canada Meghan 148 5'7 2/12/1987
2 Women Canada Rebecca 148 5'9 9/24/1989
3 Women Canada Laura 156 5'10 5/5/1994
4 Women Canada Jennifer 172 5'10 6/15/1989
5 Women Canada Jillian 144 5'5 3/7/1992
6 Women Canada Mélodie 159 5'6 1/7/1992
7 Women Canada Bailey 150 5'8 9/5/1990
8 Women Canada Brianne 156 5'9 5/4/1991
9 Women Canada Sarah 140 5'8 1/4/1995
10 Women Canada Haley 170 5'7 6/6/1988
11 Women Canada Natalie 180 5'10 10/17/1990
12 Women Canada Emily 130 5'7 11/28/1995
13 Women Canada Marie-Philip 160 5'7 3/28/1991
14 Women Canada Blayre 155 5'7 7/15/1993
15 Women Canada Jocelyne 139 5'6 5/19/1988
16 Women Canada Brigette 180 5'6 10/11/1992
17 Women Canada Lauriane 167 5'8 4/12/1990
18 Women Canada Laura 137 5'4 1/30/1991
19 Women Canada Meaghan 139 5'9 1/4/1985
20 Women Canada Renata 144 5'6 10/6/1994
21 Women Canada Shannon 146 5'8 8/6/1986
22 Women Canada Geneviève 136 5'8 5/5/1989
23 Women Canada Ann-Renée 160 5'9 4/10/1994
24 Men Canada Gilbert 190 5'11 1/1/1987
25 Men Canada Wojtek 220 6'3 2/24/1986
26 Men Canada Derek 187 5'9 5/4/1983
27 Men Canada Chris 194 6'0 11/11/1980
28 Men Canada Rob 214 6'3 8/12/1986
29 Men Canada Brandon 170 5'8 3/8/1990
30 Men Canada Quinton 190 6'2 1/21/1992
31 Men Canada René 216 6'2 12/10/1981
32 Men Canada Andrew 176 5'9 1/2/1983
33 Men Canada Mason 179 6'1 9/17/1985
34 Men Canada Eric 201 6'1 6/21/1990
35 Men Canada Maxim 216 6'0 3/29/1985
36 Men Canada Linden 190 6'0 7/17/1991
37 Men Canada Christian 174 5'9 5/26/1992
38 Men Canada Karl 181 5'11 11/21/1987
39 Men Canada Chris 187 6'0 10/3/1980
40 Men Canada Chay 170 5'9 12/20/1986
41 Men Canada Marc-Andre 205 6'3 3/11/1987
42 Men Canada Stefan 190 6'1 1/30/1991
43 Men Canada Cody 200 6'1 11/30/1989
44 Men Canada Mat 185 5'10 6/20/1986
45 Men Canada Maxim 198 6'0 5/24/1987
46 Men Canada Ben 181 6'2 9/11/1986
47 Men Canada Kevin 205 6'2 4/12/1990
48 Men Canada Justin 210 6'1 8/30/1986
49 Women USA Cayla 145 5'1 1/7/1999
50 Women USA Kacey 145 5'7 4/22/1987
51 Women USA Hannah 150 5'6 11/27/1993
52 Women USA Dani 148 5'5 6/30/1995
53 Women USA Kendall 123 5'2 5/25/1992
54 Women USA Brianna 150 5'4 5/13/1991
55 Women USA Meghan 164 5'10 9/3/1987
56 Women USA Kali 142 5'4 9/19/1995
57 Women USA Nicole 155 5'7 6/23/1994
58 Women USA Megan 160 5'11 5/1/1996
59 Women USA Amanda 136 5'5 8/28/1991
60 Women USA Hilary 175 5'11 7/12/1989
61 Women USA Jocelyne 150 5'6 7/3/1989
62 Women USA Monique 147 5'6 7/3/1989
63 Women USA Gigi 159 5'8 3/7/1987
64 Women USA Sidney 140 5'5 6/6/1995
65 Women USA Kelly 165 5'8 12/29/1995
66 Women USA Amanda 135 5'3 5/29/1993
67 Women USA Emily 125 5'3 6/14/1993
68 Women USA Alex 150 5'7 1/3/1992
69 Women USA Maddie 145 5'5 7/7/1997
70 Women USA Haley 140 5'6 1/3/1994
71 Women USA Lee 175 6'0 4/23/1994
72 Men USA Mark 170 5'8 8/12/1988
73 Men USA Chad 185 5'10 5/26/1989
74 Men USA Jonathan 195 6'1 1/30/1989
75 Men USA Will 195 6'2 12/19/1996
76 Men USA Chris 180 5'8 1/29/1986
77 Men USA Bobby 189 6'0 4/26/1987
78 Men USA Ryan 196 6'1 4/9/1996
79 Men USA Matt 200 6'1 7/20/1984
80 Men USA Brian 175 5'7 1/18/1979
81 Men USA Jordan 235 6'5 2/16/1997
82 Men USA Ryan 170 5'9 8/16/1985
83 Men USA Chad 185 5'11 1/26/1986
84 Men USA David 185 6'0 7/31/1984
85 Men USA Broc 170 5'9 3/24/1988
86 Men USA Brandon 196 6'1 3/22/1991
87 Men USA John 195 6'1 8/9/1986
88 Men USA Brian 174 5'9 6/1/1988
89 Men USA Garrett 178 5'9 2/22/1988
90 Men USA Bobby 190 6'2 2/29/1988
91 Men USA Jim 200 6'0 12/9/1982
92 Men USA Ryan 210 6'3 4/13/1987
93 Men USA Troy 179 6'0 9/10/1997
94 Men USA Noah 215 6'4 8/26/1982
95 Men USA James 205 6'0 2/21/1984
96 Men USA Ryan 203 6'0 11/11/1986
Hometown
Ruthven
Sudbury
Kleinburg
Pickering
Halifax
Valleyfield
St. Anne
Oakville
Hamilton
Thunder Bay
Scarborough
Saskatoon
Beauceville
Stellarton
Ste. Anne
Mallard
Beaconsfield
Hamilton
St. Albert
Burlington
Edmonton
Kingston
La Malbaie
Vancouver
Toronto
Rockland
Toronto
Lethbridge
Calgary
Oakbank
Lac La Biche
Vernon
Cochrane
Ottawa
Brossard
Wakaw
Toronto
Camrose
MacTier
Morden
L’Île-Bizard
Vancouver
Oakville
Calgary
Montreal
Spruce Grove
Montreal
Blyth
Eastvale
Westfield
Vadnais Heights
Plymouth
Palos Heights
Dousman
Danvers
Burlington
Lakewood
Farmington
Madison
Sun Valley
Grand Forks
Grand Forks
Warroad
Minnetonka
Plymouth
Montpelier
Buffalo
Delafield
Andover
Rockville
Roseville
Milford
Marysville
Ladera Ranch
Moorhead
North Reading
Marlborough
Scituate
Bellmore
Rochester
Canton
Bensalem
Abington
Buffalo
Rindge
Winter Park
Boston
Yardley
Vienna
Wilmington
Lapeer
Bloomington
Highlands Ranch
Brighton
Canton
Erie
Use lookup function to get Name,Country and DOB from Hockey Team Data
Player_ID Name Country DOB
3
25
34
45
57
65
71
79
82
86
90
Use lookup functions to get Player_id,Height,Team and Country using Player_Name
Name Player_id Height Hockey_Team Country
Marc-Andre
Stefan
Cody
Geneviève
Ann-Renée
Quinton
René
Excel
Student_Name Excel_marks Python_marks ML_Marks saurabh
SAURABH 90 89 87
Gaurav 87 67 81 Using lookup function get marks of "saurab
saurabh 80 78 80
Sandeep 76 69 71
Syam 99 95 90
python ML Total_marks
kup function get marks of "saurabh" from given table
Using Data validation to answer the following
Personal Data Table
Name Give input message as "Enter Na
Contact number Give input message as "Enter Nu
Pincode Create a drop down button for t
Date of birth Give input message as "Enter DO
Email Accept only text in email format
Give input message as "Enter Name" and give condition as "Text length should be between 5-12 characters" and error message should
Give input message as "Enter Number" and give condition as "Only whole numbers" and error message should "Enter whole numbers
Create a drop down button for this from the available pin codes in pincode table (Take some Pin Codes from the internet)
Give input message as "Enter DOB" and give condition as "date between 1/1/1995 to 1/1/2022" and error message should "You are no
Accept only text in email format "xyz@[Link]"
rs" and error message should "Enter name with in 5-12 characters
hould "Enter whole numbers only"
om the internet)
r message should "You are not eligible"