Question 1

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

Accepted Answer

A) True 
 B)False  True

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

Accepted Answer

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

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

Accepted Answer

The answer of Using the 'Text Import Wizard' or the...

Question 4

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?

Accepted Answer

Sort on the worker identification column

Question 5

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

Accepted Answer

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

Importing data from an external database into Excel using Microsoft Query is a three-step process. What are the steps?

Accepted Answer

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

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?

Accepted Answer

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®. 
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 8

Text files are also known as:

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Delimiter characters include:

Accepted Answer

A)  dollar signs and a hard return symbol 
B)  the word "delimiter" 
C)  a tab, space, or comma 
D)  a hard return symbol 
A)  dollar signs and a hard return symbol 
B)  the word "delimiter" 
C)  a tab, space, or comma 
D)  a hard return symbol

Question 11

Angela is importing a string of data that includes five-digit zip codes for 500 cities. This text file is considered:

Accepted Answer

A)  neither fixed nor delimited 
B)  fixed or delimited 
C)  delimited 
D)  fixed width 
A)  neither fixed nor delimited 
B)  fixed or delimited 
C)  delimited 
D)  fixed width

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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?

Accepted Answer

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

Question 14

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

Accepted Answer

The variables have different lengths, so

Question 15

​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

Accepted Answer

The data needs to be imported

Question 16

Repetitive tasks are best handled by copying and pasting.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Structure query language (SQL):

Accepted Answer

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

Microsoft Query is used to:

Accepted Answer

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

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

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?

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?

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^®?

Importing data from an external database into Excel using Microsoft Query is a three-step process. What are the steps?

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?

Text files are also known as:

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

Delimiter characters include:

Angela is importing a string of data that includes five-digit zip codes for 500 cities. This text file is considered:

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

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

Repetitive tasks are best handled by copying and pasting.

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

Structure query language (SQL):

Microsoft Query is used to:

Introduction to Business Analytics

Describing the Distribution of a Single Variable

Finding Relationships Among Variables

Probability and Probability Distributions

Normal, Binomial, Poisson, and Exponential Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Analysis of Variance and Experimental Design

Statistical Process Control

Filters

Exam 18: Importing Data Into Excel

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

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

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?

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

Importing data from an external database into Excel using Microsoft Query is a three-step process. What are the steps?

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?

Text files are also known as:

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

Delimiter characters include:

Angela is importing a string of data that includes five-digit zip codes for 500 cities. This text file is considered:

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

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

Repetitive tasks are best handled by copying and pasting.

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

Structure query language (SQL):

Microsoft Query is used to:

Introduction to Business Analytics

Describing the Distribution of a Single Variable

Finding Relationships Among Variables

Probability and Probability Distributions

Normal, Binomial, Poisson, and Exponential Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Analysis of Variance and Experimental Design

Statistical Process Control

Filters

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?

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^®?