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

The video tutorial explains how to perform custom sorting in Excel using custom lists. It covers setting up custom lists, using the UNIQUE function to extract unique values, and importing lists from cells. The tutorial also demonstrates how to finalize and apply custom sorting to organize data effectively.

What is the main advantage of using a custom list for sorting in Excel?

• It provides a visual representation of data.

• It automatically updates data entries.

• It enables sorting data in a user-defined order.

• It allows sorting data alphabetically.

Which of the following steps is NOT involved in setting up a custom list in Excel?

• Opening the sort dialogue box.

• Typing the desired order in a new list.

• Using the UNIQUE function.

• Adding the list to custom lists.

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

• Select the data range.

• Open Excel options.

• Type the list in a new document.

• Click on the Home tab.

What is the purpose of the UNIQUE function introduced in Excel 2021?

• To automatically fill down data entries.

• To create a visual chart of data.

• To extract a list of unique values from a column.

• To sort data alphabetically.

Why might Excel show an error when importing a list from cells?

• The cells contain simple text.

• The cells contain a formula.

• The cells are formatted as numbers.

• The cells are empty.

What is a workaround for importing a list from cells that contain formulas?

• Change the cell format to text.

• Use the SUM function to combine data.

• Delete the formulas and retype the data.

• Use the Cut and Paste Values option.

How can you ensure that a custom sort order is maintained even after deleting the original data?

• By saving the file immediately.

• By using the UNIQUE function.

• By importing the list into Excel options.

• By creating a backup of the data.