(D) Fixed field width
The different data is separated by a semi-colon. In this scenario, semi-colons indicate the breaks between data fields and should be used to format the text to columns.
This question is from the Quiz section of the first lesson “Working with Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.