worksheet manipulation

worksheet manipulation

1. can be manipulated to make it more suitable for data presentation and viewing

2. sorting

   • putting a column of data in ascending
     • appear in order from the smallest to the largest
     • appear in alphabetical order
   • putting a column of data in descending
     • appear in order from the largest to the smallest
     • appear in reverse alphabetical order

3. filtering

   • setting requirements for one or more columns of data in a worksheet
     • only records that meet the requirements will remain visible while others will be hidden