Google Sheets: Sorting and Filtering Data Quiz

What is the primary purpose of sorting data in Google Sheets?

• To create new data entries

• To organize data alphabetically or numerically

• To change the font style of data

• To delete unnecessary data

What does the 'Sort sheet' function do?

• Changes the color of the spreadsheet

• Deletes all data in the spreadsheet

• Adds a new column to the spreadsheet

• Organizes all data in the spreadsheet by one column

How can you freeze a header row in Google Sheets?

• Click Data and select Freeze

• Click View and hover over Freeze

• Click Format and select Freeze

• Click Insert and select Freeze

What is the purpose of applying a filter in Google Sheets?

• To add new rows

• To change the font size

• To display only the information you need

• To permanently delete data

What happens when you apply a filter to a column?

• The entire spreadsheet is deleted

• Only the filtered data is visible

• All data is highlighted

• A new sheet is created

What does 'Sort range' allow you to do?

• Sort data in a range of cells without affecting other content

• Sort the entire sheet by one column

• Delete a range of cells

• Add a new range of cells

How can you clear all filters in Google Sheets?

• Click the Format button

• Click the Insert button

• Click the Delete button

• Click the Filter button

What is a filter view in Google Sheets?

• A way to permanently delete data

• A way to add new data

• A way to filter data without affecting others' views

• A way to change the spreadsheet's theme

What should you do before sorting data in a worksheet?

• Delete all data

• Include a header row

• Change the font style

• Add a new column

What is the result of applying multiple filters?

• All data is deleted

• Data is narrowed down further

• A new sheet is created

• All data is highlighted