Module 6 Questions

Which of the following options best describes a .txt file?

• a. A special spreadsheet file containing dates
• b. A file used to store numbers
• c. A file used to hold data without formatting
• d. A file used to hold music files

What is a delimiter? Select the correct option.

• A way to combine data
• A way to organize data
• Something used to limit the use of data
• A process to collect data

What is unique about a .csv file? Select the correct option.

• It contains only numeric data.
• The file uses a space to separate data.
• It uses a comma as a delimiter.
• It is a file type restricted to the use of a word processing program.

Choose all the ways you can separate data within a data file.

• Tabs
• Commas
• Spaces
• Semicolons
• Colons

What does a delimiter do?

• It provides a way to give color and style to a workbook.
• It tells Excel how to organize data into columns.
• It tells Excel where to place a title for a workbook.
• It gives information about the data being imported.

What delimiter does a CSV file use? Select the correct option.

• Tab
• Spacebar
• Hash tab
• Comma

What is data?

• It’s a group of letters, numbers, and symbols that a computer can perform an operation on.
• It’s the same thing as information.
• It’s information that is used to track daily sales.
• It’s a graphical representation.

____________ is the option users use in Excel to bring in data from sources such as TXT and CSV files.

• Get and Transform Data
• Queries and Connections
• Sort and Filter
• Data Tools

What is data?

• It’s a group of letters, numbers, and symbols that a computer can perform an operation on.
• It’s the same thing as information.
• It’s information that is used to track daily sales.
• It’s a graphical representation.

Which of the following options would be the best way to separate data? Select the correct option.

• One category: Name + address + zip code + phone number
• Two categories: Name + address and zip code + phone number
• Three categories: Name & address and zip code + phone number
• Four categories: Name & address and zip code & phone number