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 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
Data tab > Connections
Connection Properties > Refresh Control
Background refresh
Refresh every __ minutes
Refresh data when opening file
on Refresh All
Answer is D. https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440?ui=en-us&rs=en-us&ad=us
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
r8d1
Highly Voted 4 years, 11 months agoMo2011
4 years, 9 months agoMo2011
4 years, 9 months agoWarpCore
Most Recent 4 years, 8 months agolyniguez
4 years, 9 months ago