What should you do?

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?
A . From the File tab, click Option, and then modify the Data option.
B . From the File tab, click Options, and then modify the General options.
C . From the Data tab, click Queries & Connections, and then edit the properties of the query.
D . From the Power Pivot model, modify the Table Behavior setting.

View Answer

Answer: C

Explanation:

https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-for-wi ndows-1524175f-777a-48fc-8fc7-c8514b984440