Câu 6: 70-779: Analyzing and Visualizing Data with Microsoft Excel

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a PivotTable and a PivotChart. You plan to share SalesResult.xlsx to several users outside of your organization. You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed. What should you do?

1. A. Modify the source of the query — đáp án hiện tại
2. B. Save the workbook as an Excel Binary Workbook (.xlsb)
3. C. From Query Editor, open the Data Source and delete the credentials
4. D. Run the Document Inspector