Filtering and Sorting
Authored by Ivy Professional School
Professional Development
Professional Development
Used 123+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
