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?

The correct answer is C. From the Data tab, click Queries & Connections, and then edit the properties of the query. https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-for- windows-1524175f-777a-48fc-8fc7-c8514b984440

Consume and transform data by using Microsoft Excel

Question

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.

How the community answered

(24 responses)

A
4% (1)
B
17% (4)
C
75% (18)
D
4% (1)

Explanation

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

Topics

#query refresh#refresh on open#query properties#workbook queries

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice