Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 - sort the given data

This video tutorial covers the use of Excel functions to perform sorting and filtering tasks. It guides viewers through creating a unique list of regions, setting up a data validation dropdown, filtering data by region, and sorting data by root and position. The tutorial emphasizes the use of the unique, filter, and sort by functions, providing step-by-step instructions for each task.

What is the first task in the sorting and filtering exercise?

• Calculate total profit

• Create a filter for the data

• Generate a unique list of regions

• Sort data by revenue

Which Excel function is used to create a unique list of regions?

• VLOOKUP

• SORT

• UNIQUE

• FILTER

What should be done if no records are found after filtering?

• Display an error message

• Show a message saying 'no records'

• Leave the cell blank

• Highlight the cell in red

Where should the data validation drop-down list be created?

• Cell F4

• Cell M1

• Cell G4

• Cell A1

What is the purpose of the sort by function in this exercise?

• To sort athletes by root and position

• To calculate total revenue

• To create a unique list of regions

• To filter data by region

In which order should the data be sorted using the sort by function?

• Alphabetical order

• Random order

• Ascending order

• Descending order

Which columns are used for sorting in the final task?

• Revenue and profit

• Date and time

• Root and position

• Country and region