Case-Based Critical Thinking Questions

Multiple Choice

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.
-Tayler wants the workbook to always display the most current values from a text file used when importing external sales data.What is the advantage of editing the properties of the connection versus editing the properties of the external data range?

A) The choices are applied to all of the external data ranges that use that connection.
B) The choices are applied only to the current workbook.
C) The choices are only applied the first time the workbook is opened after the properties have been changed.
D) There is no advantage--it would be better to edit the properties of the external data range.