What should you do first?

You have the Excel worksheet shown in the exhibit.

You need to transform the data by using Query Editor.

What should you do first?
A . From the Data tab, Click From Table/Range.
B . From the Insert tab, Click Store.
C . From the Data tab, Click Flash Fill.
D . From the Data tab, Click Consolidate.

View Answer

Answer: A

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 window.

https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-2016-a8 310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US