Microsoft Excel 2021365 - Beginner to Advanced - The SORT and SORTBY Functions

The video tutorial introduces and demonstrates the new sort and sort by functions in Excel 2021, which are part of the dynamic array functions. It explains how to use these functions to sort data efficiently, including advanced techniques and the use of tables for dynamic updates. The tutorial also covers sorting by selective columns and the limitations of sorting non-contiguous columns.

What category do the new Sort and Sort By functions belong to in Excel 2021?

• Mathematical Functions

• Lookup and Reference Functions

• Statistical Functions

• Text Functions

Which argument is mandatory when using the Sort function?

• Sort Order

• Column Headers

• Sort Index

• Array

In the Sort function, what does a sort index of -1 indicate?

• Numerical order

• Ascending order

• Descending order

• Alphabetical order

What is the default sort order when using the Sort function without specifying additional arguments?

• Descending order

• Random order

• Ascending order

• Custom order

What happens to the sorted data when the original data changes in a dynamic array?

• The sorted data remains unchanged

• The sorted data updates automatically

• The sorted data is deleted

• The sorted data is duplicated

How can you ensure that new entries are automatically included in a sorted list?

• By using a macro

• By using a table

• By using a chart

• By using a pivot table

What is a limitation of the Sort function regarding column selection?

• It cannot sort text data

• It cannot sort in descending order

• It cannot sort non-contiguous columns

• It cannot sort by multiple columns

What is the primary advantage of using the Sort By function over the Sort function?

• It can only sort numerical data

• It can sort in ascending order only

• It can sort by multiple columns

• It can sort text data

Which argument allows you to specify the column to sort by in the Sort By function?

• Array

• Sort Index

• By Array

• Sort Order

Which function allows sorting by specifying multiple columns in Excel 2021?

• Filter

• Sort

• Sort By

• VLOOKUP