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
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.