Microsoft Exam 70-779 Topic 5 Question 1 Discussion

Actual exam question for Microsoft's 70-779 exam

Question #: 1
Topic #: 5

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?

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.

Show Suggested Answer

Suggested Answer: C

by Oretha at May 04, 2022, 08:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!