Please help with step by step excel instructions.

Download the text file exploring_e10_grader_a1.txt, the XML file exploring_e10_grader_a 1.xml, and the Excel file exploring_e10_grader_a1.xlsx. Open the workbook.

In the blank worksheet in cell A1, import the text file called StatehoodTXT.

Rename the sheet as Statehood.

Use Text-2-Columns to remove the comma and the text "USA from all the state names in column A. Keep only the state names in column A. A2 should be Delaware, A3 should be Pennsylvania, etc.

Insert a column between columns B and C. Set the column width to 16. Format the new column C with the General number type. Type Statehood Year in cell C1.

Use the text function RIGHT() in cell C2 that extracts just the year from cell B2. If necessary, copy the function to the range C3 C51. Center horizontally data in column C.

Insert a new sheet named Capitals. Open the csv, file Stateabbreviations CSV. Copy and paste the headers and data from the csv file Into cell A1 of the Capitals sheet.

The Zip Code data in column E is incorrectly formatted as Scientific. Format the Zip Codes in General format.

Insert a new column between Columns D and E. Name this new column Capital, State Set the column width to 20.

Use the text function CONCATENATE() in cell E2 to combine the capital and postal abbreviation like this: Montgomery, AL. The second argument in the function must include the comma and space. Copy the function to the range E5 E53.

Name column H Combined Zip Code. In column H, write a formula using the & symbol to join the Zip Code, a hyphen, and the Zip Code Suffix into a single text string. The combined zip code for Alabama should look like 36100-2002.

Apply the Accent 1 Themed cell style to the headers in A1:H1. Apply the All Borders border style to the entire data set, including the header row.

import the CSV file called StateNicknamesCSV into a new sheet.

Rename the new sheet Nicknames.

Go back to the Statehood sheet. Add a column E called Nicknames. Use a VLOOKUP() function to add the nicknames from the nicknames sheet into column E of the statehood sheet.

Ensure that the worksheets are correctly named and placed in the following order in the workbook Statehood, Capitals, Nicknames. Delete any extra sheets. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed.