Google Sheets Sorting and Filtering Quiz

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

• To delete unnecessary data

• To automatically generate charts

• To organize and view specific data more efficiently

• To make the spreadsheet look colorful

Which option should you select to sort data alphabetically by name in Google Sheets?

• Sort by Age

• Sort by Date

• Sort by Country

• Sort by Name

What should you do if your data has a header row when sorting?

• Ignore the header row

• Delete the header row

• Include the header row in the sort

• Select the checkbox to exclude the header row

How can you sort data by age and then by country in Google Sheets?

• Sort by age only

• Use a filter instead

• Sort by country only

• Add a second sorting condition for country

In what order should the country be sorted if you want it in descending order?

• From A to Z

• By continent

• From Z to A

• By population size

What is the first step to create a filter in Google Sheets?

• Highlight the header row

• Delete unnecessary columns

• Sort the data first

• Select the data and click 'Create a filter'

How can you filter data to show only entries from the United States?

• Delete all other countries

• Sort by United States

• Clear all values and select United States

• Select all countries

What condition should you use to filter data by an age range in Google Sheets?

• Is less than

• Is between

• Is greater than

• Is equal to

Which two values do you need to enter when filtering by an age range?

• Median age

• Minimum and maximum age

• Average age

• Mode of ages

What should you do if you want to see all data again after applying a filter?

• Sort the data

• Clear the filter

• Create a new filter

• Delete the filter