Câu 27: 70-779: Analyzing and Visualizing Data with Microsoft Excel

You have a workbook query that loads data from C:\Data\Users.xlsx. You move Users.xlsx to a shared folder on the network. You need to ensure that you can refresh the data from Users.xlsx. What should you do?

1. A. From Query Editor, modify the Source step
2. B. From the Insert tab in Excel, click My Add-ins, and then manage the add-ins
3. C. From the Linked Table tab in Power Pivot, modify the Update Mode
4. D. From the Data tab in Excel, click Connections, and then modify the properties of the connection — đáp án hiện tại