Microsoft
70-779 · Question #66
70-779 Question #66: Real Exam Question with Answer & Explanation
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.
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.