6th Google Sheets Basics

Which icon in Google Sheets allows you to sort data in a column from A to Z?

• 
• 
• 
• 

Which icon is used to apply a filter to your data in Google Sheets?

• 
• 
• 
• 

What keyboard shortcut can you use to search for specific text in Google Sheets on a Mac computer?

• Option + F
• Command + S
• Control + F
• Command + F

If you want to sort a list of student names in alphabetical order, which steps should you follow?

• Select the column, click Data, then choose "Sort sheet A-Z"

• Click Insert, then choose "Sort"

• Right-click and select "Format cells"

• Click Tools, then choose "Sort"

How can you filter a list to show only rows where the "Grade" column is greater than 80?

• Use the "Find and Replace" tool

• Apply a filter, then set a condition for "Grade" > 80

• Change the cell format to "Number"

• Sort the column in descending order

If you need to find all entries for "Science Club" in a large sheet, what is the most efficient method?

• Manually scroll through the sheet

• Use the search function (Command + F) and type "Science Club"

• Sort the sheet by club name

• Change the text color

You are given a sheet with mixed data types (numbers, dates, and text) in one column. Explain how you would format the column so that all dates appear in the same format (e.g., MM/DD/YYYY).

• Sort the column alphabetically

• Apply a filter to show only dates

• Select the column, then use Format > Number > Date to standardize the date format

• Use the search function to find all dates