Excel Domain 6 Review

What is the primary characteristic of a .txt file?

• A file used to store numbers

• A file used to hold data without formatting

• A file used to hold music files

• A special spreadsheet file containing dates

What is a delimiter?

• A process to collect data

• Something used to limit the use of data

• A way to organize data

• A way to combine data

What characteristic makes a .csv file distinct from other file types?

• It is a file type restricted to the use of a word processing program.

• It uses a comma as a delimiter to separate values.

• The file uses a space to separate data.

• It contains only numeric data.

What does a delimiter do?

• It gives information about the data being imported.

• It tells Excel where to place a title for a workbook.

• It tells Excel how to organize data into columns.

• It provides a way to give color and style to a workbook.

Which of the following best describes what data is in the context of computing?

• It's a graphical representation.

• It's information that is used to track daily sales.

• It's the same thing as information.

• It's a group of letters, numbers, and symbols that a computer can perform an operation on.

In data file management, which of the following is NOT commonly used as a delimiter to separate data entries?

• Colon

• Period

• Comma

• Tabs

What is the most effective way to categorize the following data for better organization and retrieval?

• Four categories: Name, address, zip code, and phone number

• Three categories: Name & address, zip code, and phone number

• Two categories: Name + address and zip code + phone number

• One category: Name + address + zip code + phone number

What is the most effective way to organize a person's name for data management purposes?

• Just one category with last name first and first name last.

• Two categories with the first name in one category and the last name in a second category.

• Just one category with first and last name.

• Two categories with the first and last name in one category and the phone number in the second category.

How can the MID function be effectively utilized in data manipulation tasks?

• MID finds the middle columns of a group of columns within a workbook.

• The MID function takes the data to the left and the right of a category starting from the middle of the data.

• The MID function allows the user to specify a starting point and how many characters to extract from that point.

• MID allows the user to find the midpoint of a line.

When working with phone numbers in a spreadsheet, which function would you use to extract the area code from the beginning of the number?

• RIGHT

• MID

• LEFT

• PMT