Printable Loopcards | Mastering sorting and filtering in Microsoft Excel | iGCSE ICT

What are loop cards?

Loop cards are a great game that can be played individually or as a class. They are perfect for review key vocabulary or questions at the end of a topic or when revising for an exam.

Instructions

  1. Cut out the cards from the paper horizontally (but don't cut them in half!) and then shuffle them.
  2. Now start joining each question on the right hand side of the card to the matching answer on the next card.
  3. Carry on until all the cards loop together and you have competed the game!

Hint: Make sure that you set your paper to portrait to print 4 cards per sheet of A4 paper.

Edit Vocab

Sorting refers to arranging data in a specific order based on certain criteria.
What is filtering in Microsoft Excel?
Filtering refers to selecting and displaying only a subset of data based on certain criteria.
What are the different ways to sort data in Excel?
Data in Excel can be sorted in ascending or descending order based on values, text, or dates.
How do you access the sorting options in Excel?
The sorting options can be accessed from the 'Sort & Filter' option under the 'Data' tab.
Can you sort data with merged cells in Excel?
No, data with merged cells cannot be sorted in Excel.
What is a filter in Excel?
A filter is a tool that allows you to display only specific data in a worksheet based on certain criteria.
How do you apply a filter in Excel?
Filters can be applied from the 'Sort & Filter' option under the 'Data' tab.
What is the difference between 'filtering' and 'sorting' in Excel?
Sorting arranges data in a specific order, while filtering displays only a subset of data based on certain criteria.
What are the different types of filters in Excel?
There are several types of filters in Excel, including 'Text filters', 'Number filters', 'Date filters', 'Color filters', and 'Bilteral filters'.
Can you apply multiple filters in Excel?
Yes, you can apply multiple filters to a single dataset in Excel.
What is the purpose of a filter view in Excel?
A filter view is a personalized view of data that allows you to display only the data that is relevant to your needs.
How can you remove a filter in Excel?
Filters can be removed by selecting the 'Clear' option from the dropdown menu under the 'Sort & Filter' option.
What is the purpose of the 'Filter by Selected Cell's Value' option in Excel?
This option allows you to filter data based on the value of a selected cell in your worksheet.
What is the purpose of the 'Advanced Filter' option in Excel?
The advanced filter option allows you to apply complex filters based on multiple criteria.
Can you create custom filters in Excel?
Yes, you can create custom filters in Excel based on specific criteria.
What is the purpose of the 'Find & Select' option in Excel?
The 'Find & Select' option can be used to search for specific data in a worksheet based on certain criteria.
What is the difference between 'sorting' and 'grouping' in Excel?
Sorting arranges data in a specific order, while grouping combines data based on certain criteria.
What is the purpose of the 'AutoFilter' option in Excel?
The AutoFilter option allows you to quickly apply filters to a dataset based on certain criteria.
How can you revert back to the original order of data in Excel after sorting?
The original order of data can be reverted back by selecting the 'Remove Sort' option from the 'Sort & Filter' option under the 'Data' tab.
What is sorting in Microsoft Excel?