Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

Knowing how to import data into Excel is important because:
A)it allows formulas to be entered faster.
B)data entry errors are reduced.
C)leaving data in the native format can produce corruption.
D)it allows the data to be removed from Excel.
2

A CSV file:
A)uses Tab characters as delimiters.
B)must be imported through the Text Import Wizard.
C)is a type of text file.
D)is a proprietary file format.
3

All of the following are techniques for importing data into a worksheet except:
A)cut and paste.
B)database queries.
C)Text Import Wizard.
D)Goal Seek.
4

Importing data using the Excel Query Wizard:
A)requires defining a data source.
B)is more difficult than Microsoft Query.
C)requires that all data from the database be imported.
D)requires the use of text files.
5

When you are importing a text file:
A)delimiters are not used.
B)the records can be fixed length.
C)Excel automatically knows the file format.
D)you cannot save it as an Excel file.
6

When you are using a worksheet generated by a database query:
A)the data must be refreshed to reflect the current status of the database.
B)the data can only be synchronized with the database by generating a new query.
C)the data are automatically synchronized.
D)synchronization is irrelevant.
7

In creating a database query, you can limit the rows returned by the query through:
A)using a filter but not selection criteria.
B)elimination of unwanted columns.
C)creating a filter or specifying selection criteria.
D)sorting the data in ascending sequence.
8

Excel cannot import data from:
A)Access databases.
B)Oracle databases
C)FoxPro databases.
D)a bitmap graphic file.
9

When you are importing data from a Web page:
A)hyperlinks and Java scripts do not cause problems.
B)using the Import External Data tool allows easy selection of import data.
C)copy and paste techniques are appropriate for all types of Web information.
D)the data cannot be refreshed.
10

Comma-separated value file(s):
A)are recognized as a standard by most spreadsheet programs.
B)are no longer necessary because Excel Query accomplishes the same thing.
C)are more difficult to work with than the Text Import Wizard.
D)is the standard type of file used in Web pages.
11

Excel can import data from a number of file types.
A)True
B)False
12

A comma-separated value (CSV) file is not a text file type.
A)True
B)False
13

The use of delimiters means that field lengths can be variable.
A)True
B)False
14

Only tabs or spaces can be used as delimiters.
A)True
B)False
15

In a CSV file, all numeric fields must be enclosed with double quotes.
A)True
B)False
16

To retrieve data from a database, a data source definition must be created.
A)True
B)False
17

Data is retrieved from the database by generating a database query.
A)True
B)False
18

A data source definition is limited to only one query.
A)True
B)False
19

Microsoft Query is a simpler but less powerful tool than the Query Wizard.
A)True
B)False
20

Running a query again is called refreshing the data.
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2004 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


haagoffice2eOnline Learning Center

Home > Excel > Chapter 11 > Multiple Choice Quiz