Analyzing and Visualizing Data with Microsoft Excel — Question 82

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?

Answer options

• A. From the File tab, click Options, and then modify the General options
• B. From the Power Pivot model, modify the Table Behavior setting
• C. From the File tab, click Options, and then modify the Data options
• D. Run the Data tab, click Queries & Connections, and then edit the properties of the query

Correct answer: D

Explanation

The correct answer is D because editing the properties of the query allows you to set it to refresh automatically upon opening the workbook. Options A and C deal with general and data settings, which do not directly control query refresh behavior, while option B relates to the Table Behavior in Power Pivot, which is not applicable for setting automatic refresh on query data.