Deck 18: Importing Data Into Excel

Question 1

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

Answer 1

C

Question 2

Text file extensions end with:

A) *·.prn,*·txt *·xls
B) *·prn,*·txt *·csv
C) *·prn,*·txt *·doc
D) *·prn,*·txt *·jpg

Answer 2

B

Question 3

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

Answer 3

D

Question 4

If you had imported the data using 'fixed width,' how would the output have changed?

Question 5

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

Question 6

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?

Question 7

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

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 10

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 11

Text files are also known as:

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

Question 12

Repetitive tasks are best handled by copying and pasting.

Question 13

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 14

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

Question 15

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

Question 16

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

Question 17

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 18

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.