Microsoft
70-779 · Question #11
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?
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.
Consume and transform data by using Microsoft Excel
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.
Topics
#query refresh#refresh on open#query properties#workbook queries