Deck 11: Connecting to External Data

Question 1

Although $\underline {\text { 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._________________________

Answer 1

True

Question 2

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

When filtering data using the Query Wizard - Filter Data dialog box,the left column specifies the type of $\underline { \text { sort } }$ you want to make in the filter,such as "equals," "greater than," or "less than." _________________________

Question 5

A database is divided into separate tables.

Question 6

Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.

Question 7

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

Question 8

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

Question 9

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

Question 10

Saving the query to a file creates a text file containing the query's definition in XML code.

Question 11

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

Question 12

In a delimited file,the delimiter automatically determines the $\underline {\text { column } }$ break._________________________

Question 13

-The accompanying figure illustrates an example of $\underline { \text { space-delimited } }$ text._________________________

Question 14

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you want to import.

Question 15

The text from a web query is placed in a worksheet as formatted text.

Question 16

$\underline {\text { Full HTML } }$ formatting will result in imported data that most closely resembles the appearance of a webpage._________________________

Question 17

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.

Question 18

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

Question 19

One advantage of XML is that the document author can create rules specifying which elements are required and what types of values are allowed within each element.

Question 20

A data connection is like a pipeline from a data source to two or more locations in the workbook.

Question 21

The following is a common text filename extension: _______.

A)dat
B)ppt
C)xls
D)doc

Question 22

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

A)field
B)register
C)record
D)key

Question 23

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

A)samples
B)criteria
C)records
D)limiters

Question 24

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.

A)related
B)trusted
C)encrypted
D)safe

Question 25

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

A)index
B)matrix
C)delimiter
D)register

Question 26

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

A)key
B)exclamation point
C)question mark
D)plus sign

Question 27

The following is an example of a delimiter: _______.

A)#
B)$
C)tab
D)period

Question 28

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.

A)File
B)Open File
C)Open Text
D)Text Import

Question 29

_______ is a database program.

A)Word
B)Access
C)PowerPoint
D)Outlook

Question 30

You can define your own data source by clicking _______ from the list of databases in the Choose Data Source dialog box.

A)B)C)D)

Question 31

A data _______ is any file that contains the data you want to retrieve.

A)roster
B)link
C)dialog
D)source

Question 32

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

A)starting
B)origin
C)opening
D)key

Question 33

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

A)index
B)register
C)database
D)table

Question 34

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

A)field
B)register
C)record
D)key

Question 35

Unless you specify a format,Excel will apply the _______ format to all columns.

A)Text
B)General
C)Numerical
D)Logical

Question 36

You relate tables to one another by using _______ fields.

A)key
B)common
C)indexed
D)date

Question 37

You insert a new column break in the Text Import Wizard by _______ the position in the Data preview window where you want the break to appear.

A)double-clicking
B)clicking
C)triple-clicking
D)right-clicking

Question 38

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

A)HTML
B)text
C)spreadsheet
D)picture

Question 39

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

A)index
B)matrix
C)register
D)query

Question 40

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

A)space
B)comma
C)tab
D)dash

Question 41

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

A)base
B)root
C)tag
D)retrieval

Question 42

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

A)file:///drive:/path/filename
B)file://drive://path/filename
C)file://drive:/path//filename
D)file:///drive:///path///filename

Question 43

In XML,the rules about which elements are required and which are not are stored in a document called the _______.

A)schema
B)dictionary
C)index
D)glossary

Question 44

In the accompanying figure,item 3 points to the _______.

A)URL element specifying that the file is stored locally on the computer
B)path name of the folder containing the file
C)filename of the webpage
D)name of the computer or web server storing the page

Question 45

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

A)structured
B)relational
C)linked
D)trusted

Question 46

One of the advantages of using XML as a data source is that it allows you to attach,or _______,elements to specific cells in the workbook.

A)map
B)bind
C)insert
D)pin

Question 47

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

A)schema
B)XML
C)RTD
D)real

Question 48

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

A)FTP
B)URL
C)HTTP
D)HTML

Question 49

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

A)coding
B)data values
C)data integrity
D)external data

Question 50

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

A)URL element specifying that the file is stored locally on the computer
B)path name of the folder containing the file
C)filename of the webpage
D)name of the computer or web server storing the page

Question 51

Real-time _______ values from measuring devices and scientific equipment are a possible data source in Excel.

A)link
B)data
C)file
D)map

Question 52

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

A)order
B)filter
C)strike
D)rekey

Question 53

Databases such as those created in Access are examples of _______ databases which reduce data redundancy and increase data integrity.

A)pivot
B)relational
C)linked
D)embedded

Question 54

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.

A)apps
B)add-ons
C)plug-ins
D)modules

Question 55

To select fields within the Query Wizard,you can _______ the field name and Excel will automatically move it to the list of selected columns in your query.

A)click
B)double-click
C)triple-click
D)right-click

Question 56

The _______ formatting option retrieves all simple as well as advanced HTML formatting features,including hyperlinks.

A)Full
B)Full HTML
C)Rich text
D)Default

Question 57

In the accompanying figure,item 2 points to the _______.

A)URL element specifying that the file is stored locally on the computer
B)path name of the folder containing the file
C)filename of the webpage
D)name of the computer or web server storing the page

Question 58

The name of each element in an XML document is contained in a(n)_______.

A)link
B)tag
C)file
D)anchor

Question 59

The _______ formatting only option retrieves the text from a web query along with simple formatting,but not advanced formatting such as hyperlinks or complicated table structures.

A)Rich text
B)Text
C)Default
D)Normal

Question 60

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

A)opening
B)index
C)closing
D)map

Question 61

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

Question 62

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.

A)Open Office
B)Excel
C)Access
D)Microsoft

Question 63

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 64

After opening a workbook,Audra 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?

A)Refresh
B)Refresh All
C)Update
D)Update All

Question 65

A(n)____________________ is a collection of data arranged in rows and columns.

Question 66

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

A)ODC
B)UDC
C)OLE
D)SQL

Question 67

A(n)____________________ file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.

Question 68

Each row of a database table,called a(n)____________________,displays a collection of characteristics of a particular person,place,or thing.

Question 69

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

Question 70

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

Question 71

William works for a nationwide real estate agency. He uses the agency's website to promote the latest homes. He uses Access to store information concerning the home and Excel to analyze the data. Fall open houses include homes in Seattle, Chicago, and Denver. Spring open houses include tours of homes in Washington, D.C., New Mexico, Alaska, and Montana. Summer home tours include Paris, Rome, Denmark, and Australia.
William wants Excel to automatically refresh the connection between his Excel workbook and his Access database whenever the workbook is opened.He should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should he take to open the Connection Properties dialog box?

A)Click the DATA tab on the Ribbon, click the Connections button in the Connections group, then click the Connection button.
B)Click the DATA tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button.
C)Click the EDIT tab on the Ribbon, then click the Connections button in the Connections group.
D)Click the EDIT tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button.

Question 72

In a(n)____________________ text file,each column will start at the same location in the file.

Question 73

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.

A)Next
B)Number
C)Advanced
D)General

Question 74

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

Question 75

William works for a nationwide real estate agency. He uses the agency's website to promote the latest homes. He uses Access to store information concerning the home and Excel to analyze the data. Fall open houses include homes in Seattle, Chicago, and Denver. Spring open houses include tours of homes in Washington, D.C., New Mexico, Alaska, and Montana. Summer home tours include Paris, Rome, Denmark, and Australia.
William 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,William should click the From Other Sources button in the Get External Data group on the DATA tab,and then click _______.

A)From XML Document
B)From XML Source
C)From XML Documentation
D)From XML Data Import

Question 76

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.

Question 77

To prevent other users from updating a data source without permission,what should Audra do?

A)Define the data source.
B)Remove the connection.
C)Require a password.
D)Nothing-Excel cannot prevent data from being refreshed.

Question 78

Audra wants the workbook to always display the most current values from a text file used when importing external sales data.What is the advantage of editing the properties of the connection versus editing the properties of the external data range?

A)The choices are applied to all of the external data ranges that use that connection.
B)The choices are applied only to the current workbook.
C)The choices are only applied the first time the workbook is opened after the properties have been changed.
D)There is no advantage-it would be better to edit the properties of the external data range.

Question 79

William works for a nationwide real estate agency. He uses the agency's website to promote the latest homes. He uses Access to store information concerning the home and Excel to analyze the data. Fall open houses include homes in Seattle, Chicago, and Denver. Spring open houses include tours of homes in Washington, D.C., New Mexico, Alaska, and Montana. Summer home tours include Paris, Rome, Denmark, and Australia.
William wants his connection files listed in the Existing Connections dialog box.He should save the connections in the _______ folder.

A)My Connections
B)My Data Sources
C)My Documents
D)My Sources

Question 80

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.

A)Delete
B)Remove
C)Omit
D)Detach