Valid 70-779 Dumps shared by ExamDiscuss.com for Helping Passing 70-779 Exam! ExamDiscuss.com now offer the newest 70-779 exam dumps, the ExamDiscuss.com 70-779 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-779 dumps with Test Engine here:
You have the Excel worksheet shown in the exhibit. You need to transform the data by using Query Editor. What should you do first?
Correct 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- a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US