Audra Is a Manager in the Sales Department for Creative

Multiple Choice

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.