Deck 11: Connecting to External Data

Question 1

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.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

Databases such as those created in Access are examples of relational databases.

Answer 3

True

Question 4

Text files are rarely used for storing data.

Question 5

If a break is in the wrong location in the Data preview window,you double-click it to move it to a new location in the window.

Question 6

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

Question 7

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

Question 8

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

Question 9

In addition to delimited text,you can also organize data with a fixed-width file.

Question 10

Most software programs can both save and retrieve data in a text file format.

Question 11

When using the Text Import Wizard,you can specify a column's format before the column is imported.

Question 12

By default,the Text Import Wizard will start importing text with the first row of the file.

Question 13

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

Question 14

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.

Question 15

When you save a query,you are actually placing the query choices you have made into a file.

Question 16

Excel can open a text file into a worksheet,where you can then format it as you would any data.

Question 17

Microsoft supports a library of built-in Web queries.

Question 18

Only a few types of computers can read text files.

Question 19

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

Question 20

You cannot specify how you want the data to appear in a query.

Question 21

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

Question 22

In the Text Import Wizard,the Preview window shows the initial rows of the text file._________________________

Question 23

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 24

When using the Text Import Wizard,skip importing a column by clicking the column in the Row preview box and then clicking the Do not import (skip)option button._________________________

Question 25

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

Question 26

A delimiter separates one row of data from another._________________________

Question 27

A text file can contain ____.

A) formulas
B) special fonts
C) graphics
D) none of the above

Question 28

The following is an example of a delimiter: ____.

A) space
B) comma
C) tab
D) all of the above

Question 29

Rich text formatting will result in imported data that most closely resembles the appearance of a Web page._________________________

Question 30

Databases contain information stored in the form of lists._________________________

Question 31

Web query files are simple XML files,so you can view and edit their contents in Notepad._________________________

Question 32

Because a text file does not contain formatting codes to give it structure,a program needs another way to understand the file contents._________________________

Question 33

The accompanying figure illustrates an example of space-delimited text._________________________

Question 34

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

A) HTML
B) text
C) spreadsheet
D) both a.and b.

Question 35

The item marked 1 in the accompanying figure is the row or field in a database table._________________________

Question 36

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

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

Question 37

The point at which one column ends and another begins in the Text Import Wizard is called a column cease._________________________

Question 38

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

Question 39

The item marked 2 in the accompanying figure is the column or record in a database table._________________________

Question 40

A(n)space delimiter is often the best way of separating text columns because it permits spaces and commas within each column._________________________

Question 41

The following is a possible data source for Excel: ____.

A) dBASE file
B) MS Access Database
C) Excel file
D) all of the above

Question 42

When you want to look only at specific information from a database,you create a(n)____.

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

Question 43

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 44

You can delete an extra column break in the Data preview window of the Text Import Wizard by ____ it.

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

Question 45

The following is a NOT a common text filename extension: ____.

A) dat
B) prn
C) csv
D) doc

Question 46

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

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

Question 47

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

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

Question 48

In a ____ file,the wizard guesses the locations of the column breaks.

A) fixed-width
B) tab-delimited
C) column-delimited
D) space-delimited

Question 49

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 50

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 51

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 52

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

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

Question 53

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

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

Question 54

The ____ filename extension identifies a file as a text file.

A) tex
B) text
C) txt
D) tt

Question 55

You relate tables to one another by using ____ fields.

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

Question 56

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 57

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

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

Question 58

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

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

Question 59

____ is a database program.

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

Question 60

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

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

Question 61

The default folder for queries is the ____ folder on the hard disk.

A) Templates
B) Queries
C) Database
D) Data

Question 62

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) common

Question 63

____ has been widely used in database programs,Web programming,and word processing.

A) XML
B) JavaScript
C) Perl
D) HTML

Question 64

Microsoft Query is a(n)____ that includes several tools that allow you to create even more complex queries.

A) template
B) Office program
C) cube
D) PivotTable

Question 65

The following is a possible data source: ____.

A) databases
B) text files
C) other Excel workbooks
D) all of the above

Question 66

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 67

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 68

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

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

Question 69

Queries saved in the Queries folder will display on the Queries tab of the ____ dialog box,giving you quick and easy access to your saved queries.

A) Find Queries
B) Choose Data Source
C) Use Queries
D) Storing Data

Question 70

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

A) hyperlink
B) tag
C) file
D) schema

Question 71

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

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

Question 72

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 73

The ____ is the address of a Web page.

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

Question 74

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 75

You can retrieve the Web page format using ____,which is the default option.

A) HTML formatting
B) Rich text formatting
C) Excel formatting
D) None

Question 76

The ____ Wizard lets you preview the structure of the database and its contents.

A) Data
B) Query
C) Source
D) Database

Question 77

If you refresh external data in the ____,you can work on other portions of the workbook as you wait for the data to be retrieved.

A) view
B) background
C) window
D) marquee

Question 78

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 79

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 80

To create a Web query,you need to know the ____ of the resource (usually a Web page)you are accessing.

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