Microsoft
70-779 · Question #11
70-779 Question #11: Real Exam Question with Answer & Explanation
Sign in or unlock 70-779 to reveal the answer and full explanation for question #11. The question stem and answer options stay visible for context.
Question
You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook. What should you do?
Options
- AFrom the File tab, click Option, and then modify the Data option.
- BFrom the File tab, click Options, and then modify the General options.
- CFrom the Data tab, click Queries & Connections, and then edit the properties of the query.
- DFrom the Power Pivot model, modify the Table Behavior setting.
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.