Exam 11: Connecting to External Data

Database tables can be inserted directly into PivotCharts and ____________________.

When the location of a data source is defined as a(n)_______ location,Excel will access the connection to the data source without prompting you to confirm that the connection is secure.

In the Query Wizard,click the _______ in front of a table name to expand the display of fields in that table.

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

A _______ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column.

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

Define XML and discuss its applications.Define each of the following terms: elements,root element,tag,data map,and schema.

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

-The item marked 1 in the accompanying figure is the row or $\underline {\text { field } }$ in a database table._________________________

In an XML element,a(n)_______ tag marks the end of the data value.

A(n)____________________ is a symbol that separates one column of data from another.

The following is a common text filename extension: _______.

One of the advantages of XML is that the XML author defines what constitutes a valid document. Documents that fail to meet the rules can be rejected by an XML program as invalid,thus ensuring _______.

-The item marked 2 in the accompanying figure is the column or $\underline { \text { record } }$ in a database table._________________________

Once you insert the _______ function into a cell,the value of the cell will display the latest value retrieved from a measuring device.

Data ____________________ can be databases,text files,or other Excel workbooks.

If you want to extract only specific records when you query a database,your query would contain _______.

The row at which you begin the import process is called the _______ row.

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.

What are the steps to filter data in a query?