Beginning at cell A5 of the '$5,000 Donors' worksheet, import the data from the tab-delimited source file, contributors.txt, located in the Documents folder. (Accept all defaults.)

1. Select A5. 2. On the Data tab, in the Get & Transform Data group, click From Text/CSV. 3. Click on File, then select Open. 4. In the Import Data dialog box, then double-click it. 5. Locate the contributors.txt file in the Documents folder, then double-click it. 6. Click Next…

Create and manage documents

Question

Beginning at cell A5 of the '$5,000 Donors' worksheet, import the data from the tab-delimited source file, contributors.txt, located in the Documents folder. (Accept all defaults.)

Explanation

Select A5.
On the Data tab, in the Get & Transform Data group, click From Text/CSV.
Click on File, then select Open.
In the Import Data dialog box, then double-click it.
Locate the contributors.txt file in the Documents folder, then double-click it.
Click Next and Complete the operation.

Topics

#data import#tab-delimited#external data#text file import

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice