Page 12 of 13PREVNEXT

Import data: Import text files into Excel 2003

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

You're importing sales data that will be periodically updated. Which import method should you use?

On the File menu, click Open.

On the Data menu, point to Import External Data, and then click Import Data.

On the Insert menu, click Data.

On the Data menu, click Refresh Data.

Files can be imported if they have more than one type of delimiter.



You learned in the practice how to line up columns when there are two tab delimiters instead of one. Which option do you select to do this?

Fixed width.

Text qualifier.

Treat consecutive delimiters as one.

When you want to save a file you imported using the File menu method, what file format is the file saved as if you don't choose another option?

A .csv file.

An .xls file.

A .txt file.

Page 12 of 13PREVNEXT