Analyzing and Visualizing Data with Microsoft Excel — Question 5

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?

Answer options

• A. Modify the source of the query
• B. Save the workbook as an Excel Binary Workbook (.xlsb)
• C. From Query Editor, open the Data Source and delete the credentials
• D. Run the Document Inspector

Correct answer: A

Explanation

The correct answer is A because modifying the source of the query allows you to disconnect the data model while keeping the structure of the PivotTable and PivotChart intact. The other options either do not address the need to preserve the visual elements or do not remove the data from the model effectively.