Spreadsheets DOL

When you filter data, the filtered-out information is permanently deleted.

• True

• False

What is the main purpose of the “Search” function in a spreadsheet?

• To highlight all text in the spreadsheet

• To locate specific data quickly

• To automatically sort data by criteria

• To delete duplicates

Which of the following are benefits of using filters in a spreadsheet? (Select all that apply.)

• Hiding unnecessary data

• Deleting unwanted data

• Focusing on specific information

• Sorting data alphabetically

• Narrowing down large amounts of data

How can the search function improve your ability to work with large amounts of data?

• By organizing data into smaller, manageable chunks

• By quickly locating specific information within the data

• By automatically analyzing and summarizing the data

• By visualizing data trends and patterns

Match the following terms with their definitions:

• Z to A (100 to 1)

• Range

• Highlighting Data

• Data Validation

• A to Z (1 to 100)

• Conditional Formatting

• A group of cells in a spreadsheet

• Descending

• Correct Data

• Ascending