Microsoft
70-779 · Question #69
70-779 Question #69: Real Exam Question with Answer & Explanation
Sign in or unlock 70-779 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Question
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?
Options
- AFrom the Linked Table tab in Power Pivot, modify the Update Mode.
- BFrom Query Editor, modify the Source step.
- CFrom the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
- DFrom the Data tab in Excel click Connections, and then modify the properties of the connection.
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.