Deck 18: Importing Data Into Excel

Question 1

Real-world datasets usually do not require any cleansing because they do not contain missing data or typographical errors.

Answer 1

False

Question 2

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

Answer 2

Missing values are often coded with a series of 9s. Missing data should try to recovered either by examining the original dataset or survey. If the original source is not available, the researcher can try to recover it in other ways by searching for the data from other sources or imputing the value.

Question 3

A primary key contains a unique, specific value that is not duplicated through any instances within that field.

Answer 3

True

Question 4

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) Use the insert, copy, and paste commands in Excel^®.
B) Write a macro to handle this repetitive task.
C) Write instructions that incorporate the insert and paste functions.
D) Use the insert, copy, paste, and format commands in Excel^®.

Question 5

Repetitive tasks are best handled by copying and pasting.

Question 6

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,Disinfectant Spray,4.55,California

Question 7

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.

Question 8

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

Question 9

ASCII files are text files that can be opened and read in a text editor such as Notepad.

Question 10

Delimited text files include a delimiter character because the variable lengths vary in width.

Question 11

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

Question 12

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

Question 13

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

Question 14

​Consider importing the following text string with using 'Text Import Wizard' or the 'Text to Column Wizard.' Compare the appearance of the Excel^® output with and without indicating "fixed width" format.
​
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,Disinfectant Spray,4.55,California

Question 15

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?

A) single-table database
B) flat file database
C) relational database
D) web database

Question 16

Text files are also known as:

A) Excel^® spreadsheets
B) Excel^® workbooks
C) ASCII files
D) Notepad files

Question 17

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?

Question 18

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.

Question 19

ABC Manufacturing has 1630 employees. Each employee should have a distinct employee identification number. How would you suggest verifying this if all employee information, including identification number, are currently stored in a single spreadsheet?