Multiple Choice
Megan is currently working in a text file that contains a space as a delimiter.She is concerned because proper names,such as Alice Brown,should be considered one value,not two.How should these values appear in the text file to avoid being separated into two values when imported into Excel?
A) They should be surrounded by double quotes,as in "Alice Brown."
B) There should be no space between proper names,as in "AliceBrown."
C) The import wizard automatically knows these proper names are one value.
D) They should be eliminated from the text file.
Correct Answer:

Verified
Correct Answer:
Verified
Q4: If you had imported the data using
Q6: Importing data from an external database into
Q6: Text files are also known as:<br>A) Excel
Q8: Text file extensions end with:<br>A) *·.prn,*·txt *·xls<br>B)
Q9: Real-world datasets usually do not require any
Q9: The data in the accompanying figure was
Q10: Anna is getting ready to insert a
Q11: Angela is importing a string of data
Q11: Michael needs to create a database that
Q18: Structure query language (SQL):<br>A) is the "language