Microsoft
70-779 · Question #68
You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.) You need to transform the data by using Query Editor. What should you do first?
The correct answer is A. From the Data tab, click From Table/Range.. See the full explanation below for the reasoning.
Question
You have the Excel worksheet shown in the exhibit. (Click the Exhibit button.) You need to transform the data by using Query Editor. What should you do first?
Options
- AFrom the Data tab, click From Table/Range.
- BFrom the Data tab, click Flash Fill.
- CFrom the Data tab, click Consolidate.
- DFrom the Insert tab, click Store.
How the community answered
(49 responses)- A76% (37)
- B6% (3)
- C2% (1)
- D16% (8)
Community Discussion
No community discussion yet for this question.