Microsoft
70-779 · Question #66
From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table.
Sign in or unlock 70-779 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Consume and transform data by using Microsoft Excel
Question
From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table.
Options
- AFrom the Format menu, click Trim.
- BFrom the Format menu, click Clean.
- CFrom the Split Column menu, click By Delimiter.
- DFrom the Extract menu, click Last Characters.
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Split Column#delimiter#Power Query#data transformation