Quiz: Sorting and Filters
Cambridge Nationals IT Level 1/Level 2
Ready to start this lesson?
Sign in to track your progress. 10 steps including 8 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (10)
Welcome! You've already studied data validation, cell formatting, and conditional formatting. Now, let's test your knowledge of sorting and filters!
What is the main purpose of sorting data in a spreadsheet?
Start the lesson to answer this multiple choice question
Which of the following are filter options you can use in spreadsheets? (Select all that apply)
Start the lesson to answer this multi-select question
Sorting arranges data in {{blank0}} or {{blank1}} order.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
What happens to hidden rows when a filter is applied?
Start the lesson to answer this multiple choice question
If you apply a filter to show only values above 50 in a column, how many rows would remain if the column contains values 45, 60, 55, and 40?
Start the lesson to answer this math equation question
Filters are used to show {{blank0}} data while hiding {{blank1}} data.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Which of the following tools is most useful for analysing a large dataset with specific conditions?
Start the lesson to answer this multiple choice question
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics