Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.

Accepted Answer

The answer of A(n)____________________ is a data location that Excel...

Question 3

Each row of a database table,called a(n)____________________,displays a collection of characteristics of a particular person,place,or thing.

Accepted Answer

The answer of Each row of a database table,called a(n)____________________,displays...

Question 4

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 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 5

A(n)____________________ file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.

Accepted Answer

The answer of A(n)____________________ file contains only text and numbers...

Question 6

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 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)criteria
H)common field
I)element
J)Rich Text

Question 7

After opening a workbook,Audra wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the DATA tab?

Accepted Answer

A) Refresh 
B) Refresh All 
C) Update 
D) Update All 
A) Refresh 
B) Refresh All 
C) Update 
D) Update All

Question 8

You relate tables to one another by using _______ fields.

Accepted Answer

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

Question 9

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 his connection files listed in the Existing Connections dialog box.He should save the connections in the _______ folder.

Accepted Answer

A) My Connections 
B) My Data Sources 
C) My Documents 
D) My Sources 
A) My Connections 
B) My Data Sources 
C) My Documents 
D) My Sources

Question 10

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 11

One of the advantages of using XML as a data source is that it allows you to attach,or _______,elements to specific cells in the workbook.

Accepted Answer

A) map 
B) bind 
C) insert 
D) pin 
A) map 
B) bind 
C) insert 
D) pin

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

-The accompanying figure illustrates an example of $\underline {   \text { space-delimited } }$text._________________________

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

The following is an example of a delimiter: _______.

Accepted Answer

A) # 
B) $ 
C) tab 
D) period 
A) # 
B) $ 
C) tab 
D) period

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

One advantage of XML is that the document author can create rules specifying which elements are required and what types of values are allowed within each element.

Accepted Answer

A) True 
 B)False

Question 18

$\underline {\text { Full HTML } }$ formatting will result in imported data that most closely resembles the appearance of a webpage._________________________

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

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

A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.

Each row of a database table,called a(n)____________________,displays a collection of characteristics of a particular person,place,or thing.

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

A(n)____________________ file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.

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

After opening a workbook,Audra wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the DATA tab?

You relate tables to one another by using _______ fields.

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

One of the advantages of using XML as a data source is that it allows you to attach,or _______,elements to specific cells in the workbook.

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

$-The accompanying figure illustrates an example of \underline { \text { space-delimited } } text._$ -The accompanying figure illustrates an example of $\underline { \text { space-delimited } }$ text._

Audra 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?

The following is an example of a delimiter: _______.

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

One advantage of XML is that the document author can create rules specifying which elements are required and what types of values are allowed within each element.

$\underline {\text { Full HTML } }$ formatting will result in imported data that most closely resembles the appearance of a webpage._________________________

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

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

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

A(n)____________________ is a data location that Excel will access without prompting you to confirm that the connection is secure.

Each row of a database table,called a(n)____________________,displays a collection of characteristics of a particular person,place,or thing.

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

A(n)____________________ file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.

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

After opening a workbook,Audra wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the DATA tab?

You relate tables to one another by using _______ fields.

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

One of the advantages of using XML as a data source is that it allows you to attach,or _______,elements to specific cells in the workbook.

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

-The accompanying figure illustrates an example of space-delimited ‾\underline { \text { space-delimited } } space-delimited ​ text._________________________

Audra 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?

The following is an example of a delimiter: _______.

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

One advantage of XML is that the document author can create rules specifying which elements are required and what types of values are allowed within each element.

Full HTML ‾\underline {\text { Full HTML } } Full HTML ​ formatting will result in imported data that most closely resembles the appearance of a webpage._________________________

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

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

$-The accompanying figure illustrates an example of \underline { \text { space-delimited } } text._$ -The accompanying figure illustrates an example of $\underline { \text { space-delimited } }$ text._

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

$\underline {\text { Full HTML } }$ formatting will result in imported data that most closely resembles the appearance of a webpage._________________________