Excel - Ch. 13: Data: sort, filter, validate, dedupe
Text-only quiz: Ch. 13: Data: sort, filter, validate, dedupe
Want to study this quiz?
Copy it to your free Gradiuz library and make it your own.
Question 1
In a properly organized text file for Excel import, what separates data elements that will become columns?
- delimiters
- blank spaces
- new lines
- special characters like asterisks
Question 2
True or False: When importing a text file into Excel, each line in the text file typically corresponds to a column in Excel.
- True
- False
Question 3
Which Excel tab contains the options for importing data?
Fill in the blank
Question 4
After selecting the "Data" tab, which option should be chosen to import a text file?
- From Text/CSV
- From Web
- From Table/Range
- From Picture
Question 5
Which of the following are examples of delimiters that can separate data in a text file for Excel import?
- commas, tabs, or semicolons
- periods, question marks, or exclamation points
- spaces, underscores, or hyphens
- colons, slashes, or backslashes
Question 6
True or False: Importing data from a text file into Excel is described as a simple and easy process.
- True
- False
Question 7
What do the elements separated by a chosen delimiter in a text file represent when imported into Excel?
Fill in the blank
Question 8
What tool does Excel prompt the user with to assist in importing data?
- Text Import Wizard
- Data Validation Tool
- Conditional Formatting Wizard
- PivotTable Wizard
Question 9
The Text Import Wizard automatically detects the file type and never requires manual selection.
- True
- False
Question 10
When importing data from a text file, what must the user choose to separate the data?
- the delimiter that separates your data
- the font style
- the worksheet background color
- the number of rows to import
Question 11
Excel provides a preview of how data will be split based on the chosen delimiter.
- True
- False
Question 12
Which of the following is a valid data format option for a column during data import?
- Text
- Bold
- Italic
- Underline
Question 13
During data import, users can specify the data format for each column, with options such as General, Text, and __________.
Fill in the blank
Question 14
Where can imported data be placed in an Excel workbook?
- a new worksheet or an existing one
- only a new worksheet
- only an existing worksheet
- only a hidden worksheet
Question 15
Imported data can only be placed in a new worksheet.
- True
- False
Question 16
What is a recommended action after importing data into Excel?
- carefully examine it to ensure accuracy and correctness
- immediately delete the source file
- share the workbook without review
- apply a password to the workbook
Question 17
After importing data, adjustments such as formatting cells and adjusting __________ can be made.
Fill in the blank
Question 18
It is not necessary to save the workbook after importing and reviewing data, as changes are automatically preserved.
- True
- False
Question 19
What action should be taken after importing and reviewing data to preserve changes?
- save your workbook
- close the workbook without saving
- export the data to a new text file
- print the worksheet
Question 20
What is the primary purpose of sorting and filtering data in Excel?
- effectively organizing and analyzing data
- creating advanced pivot tables
- designing custom macros
- generating complex statistical reports
Made with Gradiuz
Turn any PDF into quizzes, flashcards and summaries - free.