Question 1

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  False

Question 2

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

Question 3

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 A

Question 4

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

Accepted Answer

The data needs to be imported

Question 5

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 6

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 7

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 8

Text file extensions end with:

Accepted Answer

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

Question 9

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 se

Question 10

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

Question 11

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 12

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

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

Repetitive tasks are best handled by copying and pasting.

Accepted Answer

A) True 
 B)False

Question 16

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

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

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

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?

Structure query language (SQL):

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

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

Text files are also known as:

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

Text file extensions end with:

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?

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?

Microsoft Query is used to:

Delimiter characters include:

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

Repetitive tasks are best handled by copying and pasting.

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

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

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?

Introduction to Data Analysis and Decision Making

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

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

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?

Structure query language (SQL):

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

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

Text files are also known as:

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

Text file extensions end with:

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?

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?

Microsoft Query is used to:

Delimiter characters include:

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

Repetitive tasks are best handled by copying and pasting.

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

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

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?

Introduction to Data Analysis and Decision Making

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