Microsoft Excel 2021365 - Beginner to Advanced - The SORTBY Function

The video tutorial explains the differences between the sort and sort by functions in Excel. It demonstrates how to use the sort by function to sort data based on different criteria, such as the number of five-star reviews or genre. The tutorial uses a data set of well-known books to illustrate sorting techniques, including sorting by multiple columns. The video emphasizes the flexibility of the sort by function in organizing data without needing to display the sorting criteria in the output table.

What is the primary difference between the Sort and Sort By functions in Excel?

• Sort By can only sort in ascending order.

• Sort By requires more data than Sort.

• Sort By allows sorting by another array, not just ascending or descending.

• Sort By is used for filtering data.

Which of the following is a mandatory argument for the Sort By function?

• Sort Order

• Column Width

• Array

• Filter

In the example provided, which column was used to sort the data in descending order?

• Genre

• Five Star Reviews

• Book Title

• Author

What does the Sort By function allow you to do that the regular Sort function does not?

• Change data types

• Filter data

• Sort by ascending order only

• Sort by multiple columns

When sorting by genre, what additional sorting was applied in the example?

• Sorting by one-star reviews

• Sorting by author name

• Sorting by book title

• Sorting by publication date

Which Harry Potter book received the most one-star reviews according to the example?

• Harry Potter and the Sorcerer's Stone

• Harry Potter and the Deathly Hallows

• Harry Potter and the Goblet of Fire

• Harry Potter and the Chamber of Secrets

What is a key advantage of using the Sort By function?

• It automatically filters out duplicates.

• It requires less data input than Sort.

• It allows sorting by a specified column rather than just order.

• It can only sort numerical data.