Chapter 4

Chapter 4

1. rows & columns

   • rows
     • range of cells that goes across a spreadsheet
   • columns
     • used to organise data
     • range of cells that go down a spreadsheet

2. cells

   • an individual data store identified by a column and row eg A6
   • every cell is uniquely identifiable
   • cells can be formatted
     • cells can be protected and hidden
   • labels
     • any text in a cell
   • data
     • any values entered for the use of calculation
   • formula/functions
     • mathemtical calculations carried out automatically

3. worksheet

   • large grid of cells on a single sheet

4. workbook

   • a collection of more than one worksheet in the same spreadsheet
   • saved as a single entity
     • easy to backup and send to others
   • different access rights can be given