Case-Based Critical Thinking Questions
Case 11-1
Tayler is a manager in the Sales Department for BusyBody Toymakers.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,BusyBody Toymakers maintains a database with detailed financial information and sales figures.Tayler uses Excel to analyze data from external data sources.
-After opening a workbook,Tayler wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the Data tab?
A) Refresh
B) Refresh All
C) Update
D) Update All

Question

Quizplus · Accepted Answer

Tayler should click the "Refresh All" button in the Connections group on the Data tab to update all of the external data ranges in the workbook. This option will update all connections in the workbook, whereas the "Refresh" button only updates the selected connection. The "Update" and "Update All" options do not exist in the Connections group on the Data tab.