Question 1

A text file can contain ____.

Accepted Answer

A)  formulas 
B)  special fonts 
C)  graphics 
D)  none of the above 
A)  formulas 
B)  special fonts 
C)  graphics 
D)  none of the above

Question 2

When the location of a data source is defined as a(n)____ location,Excel will access the connection to the data source without prompting you to confirm that the connection is secure.

Accepted Answer

A)  related 
B)  trusted 
C)  encrypted 
D)  safe 
A)  related 
B)  trusted 
C)  encrypted 
D)  safe

Question 3

By default,the Text Import Wizard will start importing text with the first row of the file.

Accepted Answer

A) True 
 B)False

Question 4

Excel can open a text file into a worksheet,where you can then format it as you would any data.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

In a ____ file,the wizard guesses the locations of the column breaks.

Accepted Answer

A)  fixed-width 
B)  tab-delimited 
C)  column-delimited 
D)  space-delimited 
A)  fixed-width 
B)  tab-delimited 
C)  column-delimited 
D)  space-delimited

Question 8

Because a text file does not contain formatting codes to give it structure,a program needs another way to understand the file contents._________________________

Accepted Answer

A) True 
 B)False

Question 9

$ \begin{array}{llll}\text { Symbol } & \text { High } & \text { LOw } & \text { Yield } \ \text { AA } & 69.5 & 49.1 & 1.3 \ \text { ABF } & 28.3 & 19.5 & 21.1 \ \text { ALD } & 44.7 & 38.6 & 5.8 \ \text { ALK } & 30.7 & 16.3 & 1.3\end{array} $
-The accompanying figure illustrates an example of space-delimited text._________________________

Accepted Answer

A) True 
 B)False

Question 10

A(n)____________________ source is any file that contains the data you want to retrieve.

Accepted Answer

The answer of A(n)____________________ source is any file that contains...

Question 11

If you want to extract only specific records when you query a database,your query would contain ____.

Accepted Answer

A)  samples 
B)  criteria 
C)  records 
D)  limiters 
A)  samples 
B)  criteria 
C)  records 
D)  limiters

Question 12

A delimiter separates one row of data from another._________________________

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of data stored in rows and columns

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

When you want to look only at specific information from a database,you create a(n)____.

Accepted Answer

A)  index 
B)  matrix 
C)  register 
D)  query 
A)  index 
B)  matrix 
C)  register 
D)  query

Question 15

-In the accompanying figure,what range of cells includes a number format?

Accepted Answer

A)  A1:D20 
B)  A2:D20 
C)  A5:D20 
D)  B5:D20 
A)  A1:D20 
B)  A2:D20 
C)  A5:D20 
D)  B5:D20

Question 16

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

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains the rules required for correctly inserting data into an XML document

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 19

In the Query Wizard,you can preview the contents of each field in the table by selecting it and then clicking the ____________________ button.

Accepted Answer

The answer of In the Query Wizard,you can preview the...

Question 20

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you do not want to import.

Accepted Answer

A) True 
 B)False

A text file can contain ____.

When the location of a data source is defined as a(n)____ location,Excel will access the connection to the data source without prompting you to confirm that the connection is secure.

By default,the Text Import Wizard will start importing text with the first row of the file.

Excel can open a text file into a worksheet,where you can then format it as you would any data.

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

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

In a ____ file,the wizard guesses the locations of the column breaks.

Because a text file does not contain formatting codes to give it structure,a program needs another way to understand the file contents._________________________

Symbol High LOw Yield AA 69.5 49.1 1.3 ABF 28.3 19.5 21.1 ALD 44.7 38.6 5.8 ALK 30.7 16.3 1.3 -The accompanying figure illustrates an example of space-delimited text._________________________

A(n)____________________ source is any file that contains the data you want to retrieve.

If you want to extract only specific records when you query a database,your query would contain ____.

A delimiter separates one row of data from another._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of data stored in rows and columns

When you want to look only at specific information from a database,you create a(n)____.

-In the accompanying figure,what range of cells includes a number format?

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the rules required for correctly inserting data into an XML document

In the Query Wizard,you can preview the contents of each field in the table by selecting it and then clicking the ____________________ button.

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you do not want to import.

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

A text file can contain ____.

When the location of a data source is defined as a(n)____ location,Excel will access the connection to the data source without prompting you to confirm that the connection is secure.

By default,the Text Import Wizard will start importing text with the first row of the file.

Excel can open a text file into a worksheet,where you can then format it as you would any data.

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

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

In a ____ file,the wizard guesses the locations of the column breaks.

Because a text file does not contain formatting codes to give it structure,a program needs another way to understand the file contents._________________________

Symbol High LOw Yield AA 69.5 49.1 1.3 ABF 28.3 19.5 21.1 ALD 44.7 38.6 5.8 ALK 30.7 16.3 1.3 -The accompanying figure illustrates an example of space-delimited text._________________________

A(n)____________________ source is any file that contains the data you want to retrieve.

If you want to extract only specific records when you query a database,your query would contain ____.

A delimiter separates one row of data from another._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of data stored in rows and columns

When you want to look only at specific information from a database,you create a(n)____.

-In the accompanying figure,what range of cells includes a number format?

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the rules required for correctly inserting data into an XML document

In the Query Wizard,you can preview the contents of each field in the table by selecting it and then clicking the ____________________ button.

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you do not want to import.

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