Posted by: Pdfprep
Post Date: November 2, 2020
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.
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
Leave a Reply