Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) B) C) D)

Question 3

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

Accepted Answer

A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 4

_______ is a database program.

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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?

Accepted Answer

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

A database is divided into separate tables.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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.

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

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.

Accepted Answer

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

Question 15

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

Accepted Answer

The answer of When using a website as a data...

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the collection of characteristics of a particular person,place,or thing

Accepted Answer

A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 17

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

Accepted Answer

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

Question 18

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.

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

____________________ are the conditions that limit the number of records displayed in the results of a query.

Accepted Answer

The answer of ____________________ are the conditions that limit the...

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

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

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

_______ is a database program.

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

A database is divided into separate tables.

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

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.

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

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

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

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

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the collection of characteristics of a particular person,place,or thing

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

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 data _______ is any file that contains the data you want to retrieve.

____________________ are the conditions that limit the number of records displayed in the results of a query.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 11: Connecting to External Data

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

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

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

_______ is a database program.

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

A database is divided into separate tables.

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

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.

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

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

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

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

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the collection of characteristics of a particular person,place,or thing

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

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 data _______ is any file that contains the data you want to retrieve.

____________________ are the conditions that limit the number of records displayed in the results of a query.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Collaborating on a Shared Workbook

Managing Your Files

Filters

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