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.Audra 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.

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.​Audra 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.

Quizplus · Accepted Answer

Editing the properties of the connection will ensure that the choices made are applied to all external data ranges connected to that source. This means that Audra will not need to make the same changes for every external data range individually, saving time and effort.

Audra Is a Manager in the Sales Department for Creative