Microsoft Excel 2021365 - Beginner to Advanced - Sorting Using a Custom List

The video tutorial explains how to sort data using custom lists in Excel. It begins by introducing the concept of custom sorting, which allows users to sort data in a specific order beyond the default A-Z or Z-A options. The tutorial then guides viewers through creating a custom list by typing the desired order in a blank cell and setting it up in Excel's advanced settings. It also covers how to import existing lists and apply them to sort data. Finally, the video demonstrates using the custom list as a sort order and confirms that deleting the original entries does not affect the custom sort order.

Why might you need to use a custom sort order instead of the standard A-Z or Z-A options?

• To sort data alphabetically

• To sort data by color

• To sort data in a specific order not covered by standard options

• To sort data numerically

What is the first step in creating a custom list for sorting?

• Importing a list from another spreadsheet

• Writing out the desired sort order in a blank cell

• Using the fill handle to complete the list

• Sorting the data A-Z

Where do you go to set up a custom list in a spreadsheet?

• File > Options > Advanced settings

• Data tab

• Insert tab

• Home tab

How can you apply a custom list to sort your data?

• By using the standard A-Z sort option

• By selecting the custom list in the sort options

• By using a pivot table

• By manually rearranging the data

What happens to the custom sort order if you delete the entries from the spreadsheet?

• The sort order is reversed

• The sort order remains unaffected

• The sort order is lost

• The sort order is automatically updated