Question 1

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

Accepted Answer

The answer of In a(n)____________________ text file,each column will start...

Question 2

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

Accepted Answer

The answer of A(n)____________________ is a collection of data arranged...

Question 3

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.

Accepted Answer

The answer of To better understand the structure of an...

Question 4

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

Accepted Answer

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

Question 5

-In the accompanying figure,Item 3 points to the ____.

Accepted Answer

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

Question 6

To manually save a connection to an ODC file,use the Export ____ File button on the Definition tab of the Connection Properties dialog box to specify the name and location of your Office Data Connection file.

Accepted Answer

A)  Connection 
B)  Data 
C)  Office 
D)  ODC 
A)  Connection 
B)  Data 
C)  Office 
D)  ODC

Question 7

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

Accepted Answer

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

Question 8

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.

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

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

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

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.

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

-In the accompanying figure,Item 3 points to the ____.

To manually save a connection to an ODC file,use the Export ____ File button on the Definition tab of the Connection Properties dialog box to specify the name and location of your Office Data Connection file.

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

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.

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

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

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 11: Connecting to External Data

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

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

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.

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

-In the accompanying figure,Item 3 points to the ____.

To manually save a connection to an ODC file,use the Export ____ File button on the Definition tab of the Connection Properties dialog box to specify the name and location of your Office Data Connection file.

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

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.

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

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

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

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

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters