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

The video tutorial demonstrates how to use horizontal sorting to organize a dataset by rearranging columns into a specified order. It explains the process of assigning a sort order to each column and applying it to the dataset. The tutorial also covers formatting adjustments, such as applying number formatting to the salary column and adjusting column widths for better visibility.

What is the main purpose of using horizontal sorting in a dataset?

• To reorder the columns for better organization

• To change the data values

• To delete unnecessary columns

• To add new columns

Which column is intended to be first in the desired order?

• Last Name

• First Name

• Department

• Title

How do you specify the order of columns in a horizontal sort?

• By changing the data type

• By renaming the columns

• By marking the order beneath the dataset

• By deleting unwanted columns

What is the final step after sorting the columns?

• Changing the font style

• Re-adding column titles and formatting

• Adding new data

• Deleting empty rows

What formatting is applied to the Salary column after sorting?

• Percentage formatting

• Currency formatting

• Date formatting

• Text formatting