Jada types out full names of students in her class in a single column,with a comma and a space between the first and the last name.She now wants to split the first and the last names into two columns.To do so,she clicks on the Text to Columns option on the Data tab in the Data Tools group.In the dialog box that appears,Jada chooses an option and clicks Next.She then clears all the check boxes under the selected option except for the Comma and Space check box and clicks Finish.Which of these can be the option Jada selected in the dialog box?
A) Delimited
B) Fixed Width
C) Fixed Length
D) Data Preview

Question

Quizplus · Accepted Answer

The option that Jada most likely selected in the dialog box is Delimited, as she is using a comma and space as delimiters to split the names into separate columns. Fixed Width and Fixed Length options are not relevant to splitting text separated by delimiters. Data Preview is not a valid option as it is not used to split text columns.

Jada Types Out Full Names of Students in Her Class