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. Excel uses a dedicated Query Editor to facilitate and display data transformations. When you select Data > Get Data, then select the data source, such as a workbook, or a database, the Navigator window appears so you can select which table (or tables) you want to use in your…

Consume and transform data by using Microsoft Excel

Question

Exhibit

Options

AFrom the Data tab, Click From Table/Range.
BFrom the Insert tab, Click Store.
CFrom the Data tab, Click Flash Fill.
DFrom the Data tab, Click Consolidate.

How the community answered

(23 responses)

A
83% (19)
B
4% (1)
C
9% (2)
D
4% (1)

Explanation

Excel uses a dedicated Query Editor to facilitate and display data transformations. When you select Data > Get Data, then select the data source, such as a workbook, or a database, the Navigator window appears so you can select which table (or tables) you want to use in your query. When you select a table, a preview of its data is shown in the right pane of the Navigator https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-2016- a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US

Topics

#Query Editor#From Table/Range#Power Query#data import

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice