please try and do 2-8 thanks!

CIL Description or Problem Statement Analysis using the Zipcode tabulation areas data from the Census Bureau Part Points Task 05 Add a border under the column headers in the zipcode table below 2 os Format the Census Date column is a short date instead of a number 3 1 Use an Excel tool learned in module 2 to split the ZCTA name column into 2 columns. One column should contain the city, Lengton, and the other should have the rest of the text, Fayette urban, KY. Put the new data in Columns and under the existing labels. Do not insert any new columns 05 In cell 19, write the name of the tool you used to sple the data iyerow) 1 Using a single sort, sort the data first ty block, low to high and secondarily by population, low to high I done correctly, all records for block 1000 will be at the top listed in order from low to high population 0.5 Create a list of Lexington Zip codes starting in cell N26 that shows each existing zip code only one time, no duplicants in column N). 1 Use the list you just created in column N to make a data validation drop down list in cell 21 (grah Azlip code most show in this cell 1 In cell F22 use a summary i function to answer the question about total population of the sipcode listed in cell a different value of zipcode is chosen from cell F21, the calculation should automatically update Press CTRL-Sto save after each problem Test to Columns Whoe bel tool or feature did you use to the CTA? Zipcode List What is the total population of the prodefined above in der Ze? Unique Zip Codes City Fayette urban Tract 101 101 101 101 101 Block 1000 1001 1001 1004 1005 County code 21067 21067 21067 21067 21067 21067 21067 21067 21667 21067 21067 21067 21067 Census Date State code 4020 21 10269 21 02 21 6026 21 40069 21 40269 21 10269 21 4000 21 40069 21 4029 21 21 10269 21 21 101 2006 ZIPS tabulation County Population area name 2CTA name (2010) 40507 Fayette Lexington Fayette urban, KY 20 40507 Fayetse KY Lexington Fayette urban, KY 6 40502 Fayette KY Lexington Fayette urban, KY 17 40507 Fayette y lington Fayette urban, KY 26 40507 Fayette KY Lexington-Fayette urban, KY 0507 Fayette y Lexington Fayette urban, KY 7 400 #ayette KY Lexington opette urban, KY 12 1000 fayette y lasington apetierbar, KY 23 40507 Fayette Lexington Fayetle, KY 40507 Fayette KY Lexington Fayette urban, KY 2 40507 Favette KY Lexington Fayette urban, KY 4 40502 Fayette KY Leton-Fayette, KY 2 40507 Fayette NY Lexington Fayette urban, KY 17 101 10: 101 1.01 1008 1009 1010 1011 1012 1013 101 101 101 1014 Start Page Problem 1 CIL Description or Problem Statement Analysis using the Zipcode tabulation areas data from the Census Bureau Part Points Task 05 Add a border under the column headers in the zipcode table below 2 os Format the Census Date column is a short date instead of a number 3 1 Use an Excel tool learned in module 2 to split the ZCTA name column into 2 columns. One column should contain the city, Lengton, and the other should have the rest of the text, Fayette urban, KY. Put the new data in Columns and under the existing labels. Do not insert any new columns 05 In cell 19, write the name of the tool you used to sple the data iyerow) 1 Using a single sort, sort the data first ty block, low to high and secondarily by population, low to high I done correctly, all records for block 1000 will be at the top listed in order from low to high population 0.5 Create a list of Lexington Zip codes starting in cell N26 that shows each existing zip code only one time, no duplicants in column N). 1 Use the list you just created in column N to make a data validation drop down list in cell 21 (grah Azlip code most show in this cell 1 In cell F22 use a summary i function to answer the question about total population of the sipcode listed in cell a different value of zipcode is chosen from cell F21, the calculation should automatically update Press CTRL-Sto save after each problem Test to Columns Whoe bel tool or feature did you use to the CTA? Zipcode List What is the total population of the prodefined above in der Ze? Unique Zip Codes City Fayette urban Tract 101 101 101 101 101 Block 1000 1001 1001 1004 1005 County code 21067 21067 21067 21067 21067 21067 21067 21067 21667 21067 21067 21067 21067 Census Date State code 4020 21 10269 21 02 21 6026 21 40069 21 40269 21 10269 21 4000 21 40069 21 4029 21 21 10269 21 21 101 2006 ZIPS tabulation County Population area name 2CTA name (2010) 40507 Fayette Lexington Fayette urban, KY 20 40507 Fayetse KY Lexington Fayette urban, KY 6 40502 Fayette KY Lexington Fayette urban, KY 17 40507 Fayette y lington Fayette urban, KY 26 40507 Fayette KY Lexington-Fayette urban, KY 0507 Fayette y Lexington Fayette urban, KY 7 400 #ayette KY Lexington opette urban, KY 12 1000 fayette y lasington apetierbar, KY 23 40507 Fayette Lexington Fayetle, KY 40507 Fayette KY Lexington Fayette urban, KY 2 40507 Favette KY Lexington Fayette urban, KY 4 40502 Fayette KY Leton-Fayette, KY 2 40507 Fayette NY Lexington Fayette urban, KY 17 101 10: 101 1.01 1008 1009 1010 1011 1012 1013 101 101 101 1014 Start Page Problem 1