Exam 11: Connecting to External Data

One way to structure text files is to use a(n)_______.

Most software programs can both save and retrieve data in a(n)_______ file format.

The point at which one column ends and another begins in the Text Import Wizard is called a(n)____________________ break.

-In the accompanying figure,item 1 points to the _______.

Excel can be used with Office _______,which are small,specialized programs that enhance the features of Excel,Word,PowerPoint,and other programs in the Office suite.

When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.

To create a web query,you need to know the _______ of the resource (usually a webpage)you are accessing.

The commands to access the data map of an XML document are part of the Excel $\underline { \text { Developer } }$ tools._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Field that is present in both tables

To facilitate real-time data acquisition,Excel provides ____________________ the function.

The point at which one column ends and another begins in the Text Import Wizard is called a column $\underline { \text { cease } }$ _________________________

The office manager at the real estate agency informs William that the internal code for Microsoft Office documents is now saved in an XML format called _______ XML.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A symbol that separates one column of data from another

Databases in which tables can be joined through the use of common fields are known as _______ databases.

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

In the Text Import Wizard,the Preview window shows the initial $\underline {\text { rows } }$ of the text file._________________________

To better understand the structure of an XML document,an XML ____________________ can be created that displays the layout of the elements in a schematic diagram.

-The item marked 1 in the accompanying figure is a _______ in a database table.

Each piece of data in an XML document is contained within a(n)____________________.