Filtering and Sorting

Filtering and Sorting

Professional Development

10 Qs

quiz-placeholder

Similar activities

SCS-Day 2019 Quiz Contest

SCS-Day 2019 Quiz Contest

Professional Development

15 Qs

SQL Statements and Queries

SQL Statements and Queries

Professional Development

15 Qs

PRIORITAS BELAJAR ATURAN BARU

PRIORITAS BELAJAR ATURAN BARU

Professional Development

10 Qs

SAMSUNG QUIZ LEAGUE (CHIRAG VICHARE'S ROYAL CHALLENGERS)

SAMSUNG QUIZ LEAGUE (CHIRAG VICHARE'S ROYAL CHALLENGERS)

Professional Development

15 Qs

Google Ads Fundamentals

Google Ads Fundamentals

Professional Development

15 Qs

HFTSK-Disbursements_Jul2024_Part2

HFTSK-Disbursements_Jul2024_Part2

Professional Development

8 Qs

INTO Artificial Intelligence

INTO Artificial Intelligence

University - Professional Development

10 Qs

Basic Fire Safety

Basic Fire Safety

Professional Development

15 Qs

Filtering and Sorting

Filtering and Sorting

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Medium

Created by

Ivy Professional School

Used 114+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • Ungraded

Full Name

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • Ungraded

Email ID

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • Ungraded

Student ID (Id No)

Evaluate responses using AI:

OFF

4.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

The rearrangement of data in ascending (A-Z) or descending (Z-A) orders is called__________ .

Filtering

Clear Rules

Sorting

Custom Filter

5.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

When data is arranged in ascending or descending order for only 1 column is called __________ .

Multiple Column Sorting

One Bar Sorting

Single Column Sorting

None of the Above

6.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

You want to sort a dataset first by "Region" (A-Z), then by "Salesperson" (A-Z), and finally by "Sales Amount" (largest to smallest). How can you achieve this in Excel?

  • Use Filter > Sort by Region, then by Salesperson, then by Sales Amount

  • Use Data > Custom Sort and add three levels of sorting

Use Data > Custom list to add three Levels of Sorting

All of these

7.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

The Sort & Filter option is present under which tab of Microsoft Excel?

View Tab

Insert Tab

Data Tab

Tools Tab

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?