Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

What are the steps to filter data in a query?

Accepted Answer

In the first step of the Query Wizard,se

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Field that is present in both tables

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 8

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

Accepted Answer

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

Question 9

-In the Horizons Fund Portfolio shown in the accompanying figure,Column A displays ticker symbols.In Excel,the MSN MoneyCentral Investor Stock Quotes Query allows you to enter up to ___ ticker symbols to retrieve current market values of the stocks.

Accepted Answer

A)  15 
B)  20 
C)  25 
D)  30 
A)  15 
B)  20 
C)  25 
D)  30

Question 10

The ____ is the address of a Web page.

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

Define XML and discuss its applications.Define each of the following terms: elements,root element,tag,data map,and schema.

Accepted Answer

Extensible Markup Language (XML)is a lan

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A question you ask about the data in a database

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 14

-In the accompanying figure,Item ____ is the name of the worksheet.

Accepted Answer

A)  1 
B)  2 
C)  4 
D)  5 
A)  1 
B)  2 
C)  4 
D)  5

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Database tables can be inserted directly into PivotCharts and ____________________.

Accepted Answer

The answer of Database tables can be inserted directly into...

Question 19

Case-Based Critical Thinking Questions
Case 11-2
Sadra works for a local travel agency.She uses the agency's Web site to promote the latest tours.She uses Access to store information concerning the tours and Excel to analyze the data.Fall tours include trips to Honolulu,Seattle,Chicago,and Denver.Spring tours include trips to Washington,D.C. ,New Mexico,Alaska,and Montana.Summer tours include Paris,Rome,Denmark,and Australia.
-Sadra wants Excel to automatically refresh the connection between her Excel workbook and her Access database whenever the workbook is opened.She should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should she 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 20

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

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

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

What are the steps to filter data in a query?

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Field that is present in both tables

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

-In the Horizons Fund Portfolio shown in the accompanying figure,Column A displays ticker symbols.In Excel,the MSN MoneyCentral Investor Stock Quotes Query allows you to enter up to ___ ticker symbols to retrieve current market values of the stocks.

The ____ is the address of a Web page.

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

Define XML and discuss its applications.Define each of the following terms: elements,root element,tag,data map,and schema.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A question you ask about the data in a database

-In the accompanying figure,Item ____ is the name of the worksheet.

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

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

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

Database tables can be inserted directly into PivotCharts and ____________________.

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

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

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

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

What are the steps to filter data in a query?

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Field that is present in both tables

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

-In the Horizons Fund Portfolio shown in the accompanying figure,Column A displays ticker symbols.In Excel,the MSN MoneyCentral Investor Stock Quotes Query allows you to enter up to ___ ticker symbols to retrieve current market values of the stocks.

The ____ is the address of a Web page.

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

Define XML and discuss its applications.Define each of the following terms: elements,root element,tag,data map,and schema.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A question you ask about the data in a database

-In the accompanying figure,Item ____ is the name of the worksheet.

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

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

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

Database tables can be inserted directly into PivotCharts and ____________________.

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

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