Chapter 18: Business Analytics_ Data Analysis _ Decision Making

1. Text files are also known as: a. Excel spreadsheets b. Excel workbooks c. ASCII files d. Notepad files 2. Anna is getting ready to insert a blank column, paste information from a previous spreadsheet into the f ...

1. Text files are also known as: a. Excel spreadsheets b. Excel workbooks c. ASCII files d. Notepad files 2. 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. 3. 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. 4. 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 5. 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 Copyright Cengage Learning. Powered by Cognero. Page 1 Name: Class: Date: Chapter 18 6. Text file extensions end with: a. *.prn, *.txt *.xls b. *.prn, *.txt *.csv c. *.prn, *.txt *.doc d. *.prn, *.txt *.jpg 7. 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 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. 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. 10. 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 Copyright Cengage Learning. Powered by Cognero. Page 2 Name: Class: Date: Chapter 18 11. ASCII files are text files that can be opened and read in a text editor such as Notepad. a. True b. False 12. Repetitive tasks are best handled by copying and pasting. a. True b. False alse 13. Delimited text files include a delimiter character because the variable lengths vary in width. a. True b. False 14. A primary key contains a unique, specific value that is not duplicated through any instances within that field. a. True b. False 15. Real-world datasets usually do not require any cleansing because they do not contain missing data or typographical errors. a. True b. False alse Copyright Cengage Learning. Powered by Cognero. Page 3 Name: Class: Date: Chapter 18 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 16. 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? 19-Nov,Maine,11764,4-Dec,New Hampshire,8794,6-Nov,Florida,9044 17. 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? 19. If you had imported the data using ‘fixed width,’ how would the output have changed?. 20. 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?