Exam 11: Connecting to External Data

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Collection of data organized to be easily retrieved and used by the end user

When using a Web site as a data source,a(n)____________________ specifies how data should be retrieved from the Web page and indicates exactly which parts of the Web page should be included and which parts should not be included.

By modifying a query's properties,you can add new columns to your worksheet,change the sort order options,or specify a filter.

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. -Tayler needs to delete a connection to a data source.She should select the connection in the list in the Workbook Connections dialog box,and then click the ____ button.

-The item marked 2 in the accompanying figure is a ____ in a database table.

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

In response to a(n)____,a database displays the records and fields that meet the question's requirements.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Format that allows for text formatting styles including boldface,italic,and color

-In the accompanying figure,Item 1 points to the ____.

When you ____ data,you specify which records you want to retrieve using specific criteria.

One way to interact with a database is with a query language.The most popular query language is ____.

If you are importing international data from a text file,click the ____ button in Step 3 of the Text Import Wizard to specify a different character for the decimal point and thousands separator.

Each column of a database table,called a(n)____________________,stores information about a specific characteristic of a person,place,or thing.

A(n)____ is a file that stores a collection of related data.

The office manager at the travel agency informs Sadra that starting with Office 2007,Microsoft moved to using the Office Open XML format which stores the XML code in a(n)____ file.

-In the Horizons Fund Portfolio shown in the accompanying figure,data is sorted by ____.

A ____ is a defined method of retrieving data from an external file.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Created to display the layout of an XML file in a schematic diagram

The general form of a URL for a file located on your computer will be ____.

Assume you have a blank workbook open in Excel.You have clicked on the Sheet1 tab and you are currently in cell A1.Describe the steps you would take to connect to a text file using the Text Import Wizard.