Solved: How To Do This Lab 1

Question Description

Step 1: Import and Clean Up Text File

  1. Download starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1.
  2. Import the text file by using the Get External Data function on the Data Ribbon. When the Text Import Wizard displays, select My Data has headers and use a comma delimiter to organize the