Multiple Choice
Which of the following actions refreshes data connections in a linked Excel workbook?
A) Click Existing Connection in the Get External Data group of the Data tab.
B) Click Refresh on the File tab.
C) Right-click on the data table and select Refresh all.
D) Click Refresh All in the Connections group of the Data tab.
Correct Answer:
Verified
Correct Answer:
Verified
Q85: Power Query can do all of the
Q86: Importing XML data into Excel enables you
Q87: Where can you open XML files in
Q88: _ is an Excel add-in that enables
Q89: Match each of the following functions to
Q90: Match each of the following concepts to
Q91: _ is an Excel add-in Business Intelligence
Q92: Which is not true about building PivotTables
Q94: Which of the following functions is best
Q95: You cannot separate data in a single