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.
-To prevent other users from updating a data source without permission,what should Tayler do?
A) Define the data source
B) Remove the connection
C) Require a password
D) Nothing--Excel cannot prevent data from being refreshed

Question

Quizplus · Accepted Answer

Requiring a password would prevent unauthorized users from updating the data source without permission. Defining the data source and removing the connection would not prevent users from updating the data source without permission. While Excel cannot completely prevent data from being refreshed, it can require a password for the connection, which would help to ensure that only authorized users can update the data source.