Excel Chapter 11 MC

Question 1

A text file can contain ____.

Answer 1

Text and numbers only

Question 2

Most software programs can both save and retrieve data in a(n) ____ file format.

Answer 2

Text

Question 3

Which of the following is an example of a delimiter?

Answer 3

Space
Comma
Tab

Question 4

One way to structure text files is to use a(n) ____.

Answer 4

Delimiter

Question 5

A ____ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column.

Answer 5

Tab

Question 6

When Excel opens a text file, the program automatically starts the ____ Wizard.

Answer 6

Text Import

Question 7

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

Answer 7

.txt

Question 8

Which of the following is a common text filename extension?

Answer 8

.dat
.prn
.csv

Question 9

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

Answer 9

Starting

Question 10

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.

Answer 10

Clicking

Question 11

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

Answer 11

Double-clicking

Question 12

In a ____ file, the wizard tries to determine the location of the column breaks for you and then places vertical lines in the Data preview window at its best guess at column locations.

Answer 12

Fixed-width

Question 13

Unless you specify a format, Excel will apply a ____ format to all columns.

Answer 13

General

Question 14

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

Answer 14

Database

Question 15

Which of the following is a database program?

Answer 15

Access

Question 16

You relate tables to one another by using ____ fields.

Answer 16

Common

Question 17

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

Answer 17

Query

Question 18

In response to a(n) ____, a database displays the records and fields that meet the question’s requirements.

Answer 18

Query

Question 19

A(n) ____ might ask something like, “What are the names of all the stocks in the portfolio, and what are their corresponding ticker symbols?”

Answer 19

Query

Question 20

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

Answer 20

Criteria

Question 21

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

Answer 21

Source

Question 22

Which of the following is a possible data source?

Answer 22

Databases
Text Files
Other Excel workbooks

Question 23

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

Answer 23

Query

Question 24

In the Query Wizard, click the ____ in front of a table name to expand the display of fields in that table.

Answer 24

Plus sign

Question 25

To select fields within the Query Wizard, you can ____ the field name and Excel will automatically move it to the list of selected columns in your query.

Answer 25

Double-click

Question 26

When you ____ data, you specify which records you want to retrieve using specific criteria.

Answer 26

Filter

Question 27

Clicking a ____ in a worksheet will activate the computer's Web browser to display the Web page associated with it.

Answer 27

Hyperlink

Question 28

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

Answer 28

Data

Question 29

One way to interact with a database is with a query language. The most popular query language is ____.

Answer 29

SQL

Question 30

A ____ is a defined method of retrieving data from an external file.

Answer 30

Connection