Spreadsheet - Organisation and Management using Sort Filters

Details
Parent Category: Application Skills
Category: Software
Hits: 3253
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

SYLLABUS 

  • organisation and management of data, using sort filters in spreadsheets 11 ATAR, 12 GEN

 

VOCABULARY

  • filter = to select or look for something
  • sort = to put existing information into a sequence

DETAILS for SORT FILTERS

Follow the instructions in the image below

 

DETAILS

  • Sorting is done so data can be seen in a way that makes it meaningful.
  • Make your spreadsheet with headings that can help sorting of information later on
  • If you know you want to sort by surname, then make a surname column
  • Later on, you can then sort by surname.
  • To Sort, select, choose Data > Sort > choose your column to sort by > choose Order by > Ok
  • it will then sort by these settings

 

FOR YOU TO DO

  1. Practice this skill with spreadsheets.

 

 

Learn more from contextures and Great explanation from Microsoft, 
 
 
 Found an error or enhancement? Please use the contact form under the Home menu item.