Question 1
(Topic 1)
A Data Analyst loads a dataset from Microsoft Excel. The following is a sample of the data. FullName contains student names. Some names contain a first name and a last name. Some names contain a first name, a middle name, and a last name. The analyst needs to divide FullName into three separate fields: one for the first name, one for the middle name, and one for the last name. The solution must minimize effort for the analyst. What should the analyst do?
Select an option, then click Submit answer.
- ○ Use the Custom Split option and specify a space as the delimiter.
- ○ Use Data Interpreter.
- ○ Use the Custom Split option for the first name and the last name and create a calculated field for the middle name.
- ○ Use the Split option.
