Microsoft Excel 2021365 - Beginner to Advanced - The SORT Function - Horizontal SORT

The video tutorial demonstrates how to sort data horizontally in Excel to identify actors who have appeared in the same movie more than once. It covers using the SORT function to arrange actor names alphabetically, employing the TEXTJOIN function to combine names into a single cell, and applying conditional formatting to highlight duplicates. The tutorial provides a step-by-step guide to managing and analyzing movie data effectively.

What is the main objective of the lesson discussed in the video?

• To create a movie database

• To find actors who have appeared in the same movie more than once

• To learn how to use Excel for financial analysis

• To learn how to use Excel for data visualization

Which Excel function is used to sort data horizontally?

• FILTER

• SORT

• VLOOKUP

• INDEX

When sorting data horizontally, what argument is used to specify sorting by column?

• FALSE

• TRUE

• ASCENDING

• DESCENDING

What function is used to combine text from multiple cells into one cell?

• MERGE

• CONCATENATE

• TEXTJOIN

• JOIN

What delimiter is used in the TEXTJOIN function to combine actor names without any separation?

• None

• Dash

• Space

• Comma

What Excel feature can be used to highlight duplicate values in a dataset?

• Pivot Table

• Data Validation

• Conditional Formatting

• Data Filter

Which movies were identified as having the same actors using the described method?

• Superbad and Insurgent

• Burn After Reading and La La Land

• The Interview and Superbad

• La La Land and The Interview