Computing

• Spreadsheets are used to store information and data
• Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns
• Workbook


  A spreadsheet file is made up of one workbook and multiple worksheets
• Worksheet


  Worksheets appear as tabs at the bottom of a workbook and can be reordered and renamed
• Cell reference


  Every cell in a spreadsheet or worksheet has a unique cell reference, which consists of a letter and a number. The letter refers to the column and the number refers to the row
• Selecting cells


  1. To select a cell, left click on it

  2. To enter data, double-click it

  3. To select multiple cells, click and hold the left mouse button and drag it in the direction of the cells you want to select
• Types of data that can be entered into a cell


  • Data - values, usually numbers but can be letters or a combination of both
  • Labels - headings and descriptions to make the spreadsheet easier to understand
  • Formulas - calculations that update automatically if referenced data changes
• Sorting cell data


  The A-Z feature automatically orders data in ascending/descending order or alphabetically
• Duplicating cell content or filling a series


  Click and drag the fill handle over the cells you want the duplicate data or series to fill