Filter the table on the "Address Book Sorted" worksheet to display only customers whose "Province" contains the text "shire". [8 points]

First Name Last Name Customer ID Date Added Street Address Street Address 2 City Province Postal Code Sweta Sneha 65 8/19/2012 4 Glenkeen Court Aghadowey Londonderry BT51 4FB Ruben Goode Antrim 5jg Tung-Xiung Wu Assignment Tasks X le of Glamorgan CF63 4LL Simon Poon Address Book East Sussex TN33 OLH Filter the table on the "Address Book Sorted" worksheet to display only customers whose Bessie Cates 32 dfordshire MK41 9DJ "Province" contains the text "shire". [8 points] Jacqueline Williamson 54 17 71 2012 45 Zrichbell court Beatora Bedfordshire mk40 2jq Deon Powell 68 8/28/2012 48 Park Road Beeston Nottingham NG9 4DE 4 Dunseverick Court, Belvior David Lanc 25 4/3/2012 Park Estate Belfast Northern Ireland BT8 7AG Sandy Metz 29 4/19/2012 98 London Road Bexhill On Sea East Sussex TN39 3JZ Susana Herrera 48 6/21/2012 Station Court Radford Way Billericay Essex cm12 0dz Henrietta Roach 57 7/18/2012 43 Beaufort Avenue Hodge Hill Birmingham West Midlands B34 6AD 39 5/19/2012 Eyrescroft Primary School Bretton PE3 8EZ Monica Hastings Peterborough Servane Crave 31 4/27/2012 79 Ashwood Drive Broadstone Dorset BH188LN Marianne D'Onofrio 38 5/16/2012 6 STAG DRIVE HUNTINGTON Cannock Staffordshire WS124UJ Rebecca Gates 41 5/25/2012 70 Goose Close Chatham Kent ME5 7SX 78 central way, Cheltenham Janet Cormier 26 4/7/2012 trade park Cheltenham Gloucestershire G151 7en Diana Dillon 12 2/21/2012 5 churton road Chester ch3 5eb CO28QA Chen Ye 7 1/28/2012 71 HOLMOAK, THE WILLOWS Colchester Jiunn Lee 56 7/13/2012 40 bowden park road Crownhill plymoth pl65nq Charlotte Bullock 63 8/10/2012 38 Lebanon Road Croydon CRO 6UR 3. Kingston Farm 6 1/23/2012 Cottages. Kingston Russell Dorchester DT29EE Monica Carey Mp Gupta 40 5/24/2012 Bydand East End Freuchie Fife KY15 7ET Bridges 61 8/8/2012 800 Second Avenue Clydebank Glasgow West Dunbartonshire G81 3LE Eric c/o MACIVER, Flat 3/7, 80 Edwardo Grubbs 9 2/5/2012 Waverley gdns Glasgow EN G41 2EG