Question 1 Importing From A Text File

Open the 111-instructors.txt file from the GMetrixTemplates folder. Indicate that the data has headers. Tabs are the delimiters.
​

1. Click the File tab
2. Ensure the Open tab is selected
3. Browse to the GMetrixTemplates folder
4. Click the File type drop-down arrow
5. Click All Files
6. Click the 111-instructors.txt file
7. Click the Open button
8. Ensure that the My data has headers check box is selected
9. Click the Next button
10. Ensure that the Tab check box is the only delimiter check box selected
11. Click the Next button
12. Click the Finish button

​Question 2 Importing from a .csv File

Import the 112-class schedule.csv file from the GMetrixTemplates folder as a table to the current worksheet.

1. Click the Data tab
2. In the Get & Transform Data group, click From Text/CSV
3. Browse to the GMetrixTemplates folder
4. Click the 112-class schedule.csv file
5. Click the Import button
6. In the preview window, click the Load dropdown and select Load To...
7. Ensure that Table is selected under Select how you want to view this data in your workbook.
8. Under Where do you want to put the data?, select Existing worksheet
9. Click OK

Question 3 Search for Data

Find all instances of the word, Yoga, on the class schedule worksheet. Then, change the first instance of the word, Yoga, to Hot Yoga.

1. In the Home tab, Editing group, click the Find & Select drop-down arrow
2. Click Find
3. Type: yoga
4. Click the Find All button
5. Click the first instance of the word, Yoga (it will take you to cell A3)
6. Change the contents of cell A3 to the words, Hot Yoga
7. Press the Enter key​

Question 4: Workbook Navigation

Navigate to the Instructor4 named range. Then, change the contents of the cell to Charles.

1. In the Home tab, Editing group, click the Find & Select drop-down arrow
2. Click Go To
3. Click Instructor4
4. Click the OK button
5. Click into cell A5
6. Change the instructor name in cell A5 to Charles
7. Press the Enter key