Name:
Class:
Date:
Indicate whether the statement is true or false.
1. A primary key contains a unique, specific value that is not duplicated through any instances within that field.
a.
True
b.
False
2. ASCII files are text files that can be opened and read in a text editor such as Notepad.
a.
True
b.
False
3. Real-world datasets usually do not require any cleansing because they do not contain missing data or typographical
errors.
a.
True
b.
False
4. Repetitive tasks are best handled by copying and pasting.
a.
True
b.
False
5. Delimited text files include a delimiter character because the variable lengths vary in width.
a.
True
b.
False
Indicate the answer choice that best completes the statement or answers the question.
6. Delimiter characters include:
a.
dollar signs and a hard return symbol
b.
the word “delimiter”
c.
a tab, space, or comma
d.
a hard return symbol
7. Angela is importing a string of data that includes five-digit zip codes for 500 cities. This text file is considered:
a.
neither fixed nor delimited
b.
fixed or delimited
c.
delimited
d.
fixed width
8. Microsoft Query is used to:
a.
delete missing observations from a spreadsheet
b.
copy and paste data within a single spreadsheet
c.
transfer data from a spreadsheet in the same workbook
d.
import data from many database packages
9. Michael needs to create a database that contains a table with information about each car produced, a table with
information about the line in which each car was produced, and a table with information about the experience of workers
on the line in which each car was produced. Which type of database would allow him to enter this information only once,
but also create three separate tables with information on the car, the line, and the workers?
Name:
Class:
Date:
a.
Single-table database
b.
Flat file database
c.
Relational database
d.
Web database
10. Text file extensions end with:
a.
*.prn, *.txt *.xls
b.
*.prn, *.txt *.csv
c.
*.prn, *.txt *.doc
d.
*.prn, *.txt *.jpg
11. Megan is currently working in a text file that contains a space as a delimiter. She is concerned because proper names,
such as Alice Brown, should be considered one value, not two. How should these values appear in the text file to avoid
being separated into two values when imported into Excel?
a.
They should be surrounded by double quotes, as in “Alice Brown.”
b.
There should be no space between proper names, as in “AliceBrown.”
c.
The import wizard automatically knows these proper names are one value.
d.
They should be eliminated from the text file.
12. Structure query language (SQL):
a.
is the “language of databases”
b.
was developed in 2010
c.
is the “language of Excel”
d.
is used to differentiate queries across packages
13. Anna is getting ready to insert a blank column, paste information from a previous spreadsheet into the first four rows
of this column, and bold the heading. And she needs to do this for all 150 product lines in her area. How is this task best
handled?
a.
Using the insert, copy, paste commands in Excel.
b.
Writing a macro to handle this repetitive task.
c.
Writing instructions that incorporate the insert and paste functions.
d.
Using the insert, copy, paste, and format commands in Excel.
14. Text files are also known as:
a.
Excel spreadsheets
b.
Excel workbooks
c.
ASCII files
d.
Notepad files
15. Importing data from an external database into Excel using Microsoft Query is a three-step process. What are the steps?
a.
Delete missing observations, use Microsoft Query to define a query, and return the data to Excel.
b.
Define the source, use Microsoft Query to define a query, and return the data to the original, external database.
c.
Define the sources, use Microsoft Query to define a query, and return the data to Excel.
d.
Open Excel, use Microsoft Query to define a query, and return the data to Excel.
Name:
Class:
Date:
16. If you had imported the data using ‘fixed width,’ how would the output have changed?
17. Using the ‘Text Import Wizard’ or the ‘Text to Column Wizard,’ import the following text string into Excel. What
does the output in Excel look like?
Apples,3.60,Washington-
DC,Red,Bananas,0.69,Brazil,Potatoes,2.13,Idaho,Milk,2.39,Wisconsin,Wheat,3.78,Kansas,Cabernet,42.77,California,Disi
nfectant Spray,4.55,California
18. ABC Manufacturing has 1630 employees. Each employee should have a distinct employee identification
number. How would you suggest confirming this if all employee information, including i.d. number, are currently stored
in a single spreadsheet?
Date
State
Tax
19–Nov
Maine
11764
4-Dec
New
Hampshire
8794
6-Nov
Florida
9044
5-Jul
Washington
13456
4-Feb
California
8435
10-Sep
North Dakota
8743
4-Jul
New York
8432
19. The data in the accompanying figure was imported using “Text Import Wizard.” How did the first three rows of text
data appear in the text file prior to importing?
20. The data in the accompanying figure was imported using ‘Text Import Wizard.’ Give an explanation for the ‘99999’
value in the Tax column. What recommendation would you make as to how to deal with this value?
Name:
Class:
Date: