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

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

Assessment

Interactive Video

Information Technology (IT), Architecture

University

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of the column headings in the data set?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the desired order of the columns in the data set?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

How do you assign a sort order to the columns?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What steps are involved in performing a horizontal sort?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

What formatting is suggested for the Salary column?

Evaluate responses using AI:

OFF