Case-Based Critical Thinking Questions

question 60

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.

---

Definitions:

Laws

The system of rules that are created and enforced through social or governmental institutions to regulate behavior.

Underage Drinking

The consumption of alcoholic beverages by individuals below the legal age for alcohol consumption in their jurisdiction.

Ethical Behavior

Conduct that is consistent with the principles of morality, including honesty, fairness, equity, and integrity, in all professional and personal actions.

Renewable Electricity

Electricity generated from renewable sources such as solar, wind, geothermal, hydro, and biomass that can be replenished naturally.