Exam 11: Connecting to External Data

A(n)____ might ask something like,"What are the names of all the stocks in the portfolio,and what are their corresponding ticker symbols?"

Although text files contain only raw,unformatted data,they are very useful in situations when you want to share data across software programs and computer systems._________________________

Eliminating columns using the Text Import Wizard is useful when there are only a few items you want to import from a large text file containing many columns.

Case-Based Critical Thinking Questions Case 11-2 Sadra works for a local travel agency.She uses the agency's Web site to promote the latest tours.She uses Access to store information concerning the tours and Excel to analyze the data.Fall tours include trips to Honolulu,Seattle,Chicago,and Denver.Spring tours include trips to Washington,D.C. ,New Mexico,Alaska,and Montana.Summer tours include Paris,Rome,Denmark,and Australia. -Sadra learns that an advantage of using XML elements in a worksheet is that it allows the user to attach elements to specific cells.To map an XML document directly into an Excel table,Sadra should click the From Other Sources button in the Getting External Data group on the Data tab,and then click ____.

____ is a database program.

To detach an Excel table from its data source,select a cell in the table,click the Table Tools Design tab,and then,in the External Table Data group,click the ____ button.

When you use Excel to connect to a text file,the ____ Wizard determines whether the data is in a fixed-width format or a delimited format.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains data in an XML document

In order to override Excel so that it always enables data sources and refreshes the connection to the source without prompting,you should define the location of the data sources as ____.

In the last part of writing a query,you specify how to sort the data.

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. -After opening a workbook,Tayler wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the Data tab?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Conditions you set to limit the number of records a database extracts

In a delimited file,the delimiter automatically determines the row break._________________________

The Text Import Wizard's attempt to define the number and location of columns is always correct.

Text files are rarely used for storing data.

-In the accompanying figure,what range of cells has the date format applied?

You relate tables to one another by using ____ fields.

Clicking a ____ in a worksheet will activate the computer's Web browser to display the Web page associated with that entry.

An XML document is structured like a tree in which elements are placed within one another,descending from a common ____ element.

A(n)____________________ is a question you ask about the data in the database.