Sorting (single and multi-column) in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does sorting data in a single column do in Google Sheets?

Sorting data in a single column arranges the rows based on the values in that column, either from smallest to largest (A to Z) or largest to smallest (Z to A). The entire row moves with the sorted column to keep data intact.

beginner

How do you sort data by multiple columns in Google Sheets?

You select the data range, then use the 'Data' menu and choose 'Sort range'. You add levels to sort first by one column, then by another, deciding the order (A to Z or Z to A) for each column.

intermediate

What is the difference between sorting a range and sorting a sheet in Google Sheets?

Sorting a range only changes the order of the selected cells, leaving the rest of the sheet unchanged. Sorting a sheet rearranges all rows in the entire sheet based on the chosen column(s).

intermediate

Which formula can you use to sort data dynamically in Google Sheets?

You can use the SORT function. For example, =SORT(A2:C10, 1, TRUE) sorts the range A2:C10 by the first column in ascending order. This formula updates automatically if the data changes.

beginner

Why is it important to select the entire data range before sorting?

Selecting the entire data range ensures that all related data in each row stays together. If you sort only one column without selecting the whole range, data in other columns will not move, causing mismatched rows.

What happens when you sort a single column in Google Sheets without selecting the entire data range?

A Nothing happens.

B The entire sheet sorts automatically.

C Only the selected column sorts, causing rows to mismatch.

D Google Sheets shows an error.

Sorting only one column without the full range moves just that column's data, breaking the row alignment.

Which menu option do you use to sort data by multiple columns in Google Sheets?

A Data > Sort range

B Insert > Sort

C Format > Sort

D Tools > Sort

The 'Sort range' option under the Data menu lets you add multiple sorting levels.

What does the SORT function in Google Sheets do?

A Sorts data dynamically based on specified columns and order.

B Deletes duplicate rows.

C Filters data by criteria.

D Merges cells.

SORT rearranges data dynamically and updates when source data changes.

If you want to sort a whole sheet by column B in descending order, what should you do?

A Use the CONCATENATE function

B Select column B only, then Data > Sort range

C Use the FILTER function

D Select all rows, then Data > Sort sheet by column B, Z → A

Sorting the whole sheet by column B descending requires selecting all rows and using 'Sort sheet by column B, Z → A'.

When sorting by multiple columns, which column is sorted first?

A The column with the fewest empty cells

B The first column you add in the sort levels

C The column with the most data

D The last column you add

Sorting happens in the order you add columns in the sort levels, starting with the first.

Explain how to sort data by multiple columns in Google Sheets and why it is useful.

Think about sorting first by one column, then by another to organize data better.

Describe the difference between sorting a range and sorting an entire sheet in Google Sheets.

Consider how much of your data you want to reorder.

Practice

1. What does the SORT function do in Google Sheets?

easy

A. It arranges data in a specified order based on one or more columns.

B. It deletes duplicate rows from the data.

C. It calculates the sum of selected cells.

D. It changes the font style of the selected cells.

Solution

1. Step 1: Understand the purpose of SORT

   The SORT function is designed to reorder data based on column values.

2. Step 2: Compare with other options

   Deleting duplicates, summing cells, or changing font are different functions, not sorting.

3. Final Answer:

   It arranges data in a specified order based on one or more columns. -> Option A

4. Quick Check:

   SORT = Arrange data order [OK]

Hint: SORT arranges data by columns, not formatting or calculations [OK]

Common Mistakes:

• Confusing SORT with SUM or formatting functions
• Thinking SORT deletes data
• Assuming SORT changes cell styles

2. Which of the following is the correct syntax to sort data in range A2:C10 by the first column in ascending order?

easy

A. =SORT(A2:C10, 1, FALSE)

B. =SORT(A2:C10, TRUE, 1)

C. =SORT(A2:C10, 1, TRUE)

D. =SORT(A2:C10, 2, TRUE)

Solution

1. Step 1: Recall SORT syntax

   The syntax is SORT(range, sort_column_index, is_ascending).

2. Step 2: Match syntax to options

   =SORT(A2:C10, 1, TRUE) uses correct order: range A2:C10, column 1, ascending TRUE.

3. Final Answer:

   =SORT(A2:C10, 1, TRUE) -> Option C

4. Quick Check:

   SORT(range, column, TRUE) = ascending [OK]

Hint: Remember: SORT(range, column_number, TRUE/FALSE) [OK]

Common Mistakes:

• Swapping the order of TRUE and column number
• Using FALSE for ascending order
• Selecting wrong column index

3. Given the data in A1:B4:
Name | Score
Alice | 85
Bob | 92
Carol | 78
What will be the result of =SORT(A2:B4, 2, FALSE)?

medium

A. Bob 92Alice 85Carol 78

B. Carol 78Alice 85Bob 92

C. Alice 85Bob 92Carol 78

D. Bob 92Carol 78Alice 85

Solution

1. Step 1: Understand sorting by second column descending

   Sorting by column 2 (Score) with FALSE means highest to lowest.

2. Step 2: Order the scores

   Scores: Bob 92, Alice 85, Carol 78. Sorted descending: 92, 85, 78.

3. Final Answer:

   Bob 92
   Alice 85
   Carol 78 -> Option A

4. Quick Check:

   SORT by Score descending = highest first [OK]

Hint: FALSE means descending order, highest values first [OK]

Common Mistakes:

• Mixing TRUE and FALSE for ascending/descending
• Sorting by wrong column index
• Ignoring header row in sorting

4. You want to sort data in A2:C10 first by column 2 ascending, then by column 3 descending. Which formula fixes the error in this incorrect formula?
=SORT(A2:C10, 2, TRUE, 3)

medium

A. =SORT(A2:C10, 3, TRUE, 2, FALSE)

B. =SORT(A2:C10, 2, TRUE, 3, FALSE)

C. =SORT(A2:C10, 3, FALSE, 2, TRUE)

D. =SORT(A2:C10, 2, TRUE, 3, TRUE)

Solution

1. Step 1: Identify correct multi-column SORT syntax

   Multi-column SORT needs pairs: column index and TRUE/FALSE for each.

2. Step 2: Fix missing TRUE/FALSE for second column

   The original formula misses the order for column 3. =SORT(A2:C10, 2, TRUE, 3, FALSE) adds FALSE for descending.

3. Final Answer:

   =SORT(A2:C10, 2, TRUE, 3, FALSE) -> Option B

4. Quick Check:

   Multi-column SORT needs column and order pairs [OK]

Hint: Always pair column number with TRUE/FALSE in SORT [OK]

Common Mistakes:

• Omitting TRUE/FALSE for each sort column
• Swapping column order and sort order
• Using wrong TRUE/FALSE for desired order

5. You have a list of employees with columns: Name (A), Department (B), and Salary (C). You want to sort the list first by Department ascending, then by Salary descending. Which formula correctly sorts this data in range A2:C100?

hard

A. =SORT(A2:C100, 1, TRUE, 3, FALSE)

B. =SORT(A2:C100, 3, FALSE, 2, TRUE)

C. =SORT(A2:C100, 2, FALSE, 3, TRUE)

D. =SORT(A2:C100, 2, TRUE, 3, FALSE)

Solution

1. Step 1: Identify sorting order for each column

   Department (column 2) ascending = TRUE; Salary (column 3) descending = FALSE.

2. Step 2: Match formula with correct column and order pairs

   =SORT(A2:C100, 2, TRUE, 3, FALSE) matches: column 2 TRUE, column 3 FALSE.

3. Final Answer:

   =SORT(A2:C100, 2, TRUE, 3, FALSE) -> Option D

4. Quick Check:

   Sort by Dept ascending, Salary descending = =SORT(A2:C100, 2, TRUE, 3, FALSE) [OK]

Hint: Sort by main column ascending, then secondary descending [OK]

Common Mistakes:

• Reversing sort order for columns
• Sorting by wrong column numbers
• Using inconsistent TRUE/FALSE values