Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Stores information about a specific characteristic of a 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
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 4

____________________ fields are the fields that appear in more than one table.

Accepted Answer

The answer of ____________________ fields are the fields that appear...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

XML stands for ____________________.

Accepted Answer

Extensible

Question 7

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

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

Microsoft supports a library of built-in Web queries.

Accepted Answer

A) True 
 B)False

Question 10

In a delimited text file,the ____________________-usually a space,a comma,or a tab-automatically determines the column break.

Accepted Answer

The answer of In a delimited text file,the ____________________-usually a...

Question 11

Only a few types of computers can read text files.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Databases contain information stored in the form of lists._________________________

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

URL stands for ____________________.

Accepted Answer

Uniform Re

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

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

Question 19

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 20

Case-Based Critical Thinking Questions
Case 11-1
Tayler is a manager in the Sales Department for BusyBody Toymakers.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,BusyBody Toymakers maintains a database with detailed financial information and sales figures.Tayler uses Excel to analyze data from external data sources.
-Tayler 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?

Accepted Answer

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Stores information about a specific characteristic of a person,place,or thing

____________________ fields are the fields that appear in more than one table.

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

XML stands for ____________________.

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

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.

Microsoft supports a library of built-in Web queries.

In a delimited text file,the ____________________-usually a space,a comma,or a tab-automatically determines the column break.

Only a few types of computers can read text files.

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

Databases contain information stored in the form of lists._________________________

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

URL stands for ____________________.

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

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

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

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.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Stores information about a specific characteristic of a person,place,or thing

____________________ fields are the fields that appear in more than one table.

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

XML stands for ____________________.

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

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.

Microsoft supports a library of built-in Web queries.

In a delimited text file,the ____________________-usually a space,a comma,or a tab-automatically determines the column break.

Only a few types of computers can read text files.

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

Databases contain information stored in the form of lists._________________________

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

URL stands for ____________________.

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

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

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

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.

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