Audra is a manager in the Sales Department for Creative Pastry Gadgets.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,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.To prevent other users from updating a data source without permission,what should Audra do?
A) Define the data source.
B) Remove the connection.
C) Require a password.
D) Nothing-Excel cannot prevent data from being refreshed.

Question

Audra is a manager in the Sales Department for Creative Pastry Gadgets.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,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​To prevent other users from updating a data source without permission,what should Audra do? 
A) Define the data source. 
B) Remove the connection. 
C) Require a password. 
D) Nothing-Excel cannot prevent data from being refreshed.

Quizplus · Accepted Answer

Audra should require a password to prevent unauthorized users from updating the data source without permission. This will add an extra layer of security to the data source and ensures that only authorized personnel can access the data.

Audra Is a Manager in the Sales Department for Creative