Wiki Sumber Informasi iSIKHNAS

Activity - examine an Excel workbook

Learning objectives

After the completion of this activity, you will be able to:

• identify and open an Excel file
• navigate from one worksheet to another
• navigate within a single worksheet, using
  • scroll bars
  • menu system
  • combinations of shortcut keys
• use zoom to view components of dataset
  • select an individual cell, or a range of cells
  • zoom to selection
• inspect the contents of a cell
• resize columns/rows
• apply/remove 'freeze panes'
  • use freeze panes to keep selected rows and columns visible when scrolling around a worksheet
• apply/remove an autofilter
  • use autofilter to inspect data.