Consider importing the following text string with using 'Text Import Wizard' or the 'Text to Column Wizard.' Compare the appearance of the Excel® output with and without indicating "fixed width" format.
Apples,3.60,Washington-
DC,Red,Bananas,0.69,Brazil,Potatoes,2.13,Idaho,Milk,2.39,Wisconsin,Wheat,3.78,Kansas,Cabernet,42.77,California,Disinfectant Spray,4.55,California
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q9: ASCII files are text files that can
Q10: Delimited text files include a delimiter character
Q11: Delimiter characters include:
A) dollar signs and a
Q12: Microsoft Query is used to:
A) delete missing
Q13: Angela is importing a string of data
Q15: Michael needs to create a database that
Q16: Text files are also known as:
A) Excel®
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents