Analyzing and Visualizing Data with Microsoft Excel — Question 2

You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model.
You discover that new rows were added to the tables in Azure SQL Database.
You need to ensure that the workbook has the new data.
What should you do?

Answer options

• A. From the Data tab, click Refresh All
• B. From the Power Pivot tab, click Update All
• C. Close and open the workbook
• D. Select a cell in the worksheet and press F5

Correct answer: C

Explanation

The correct answer is C because closing and reopening the workbook forces Excel to refresh all data connections and load the latest data. The other options, such as 'Refresh All' or 'Update All', may not apply if there is an issue with the connection or if the workbook needs to be restarted to recognize the new data.