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 decides to import data so it will be stored in an external data range.She learns that Excel automatically assigns the data range a defined name based on the filename of the _______.
A) open source
B) destination file
C) data source
D) file source

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 decides to import data so it will be stored in an external data range.She learns that Excel automatically assigns the data range a defined name based on the filename of the _______.
A) open source
B) destination file 
C) data source
D) file source

Quizplus · Accepted Answer

Excel automatically assigns the data range a defined name based on the filename of the data source, not the open source or destination file. Therefore, the correct choice is C, data source.

Audra Is a Manager in the Sales Department for Creative