Worksheets, workbooks, rows, columns, cells and ranges

Worksheets, workbooks, rows, columns, cells and ranges

1. A worksheet is a single sheet (page) of rows and columns in a workbook.

   • Data can be entered into one worksheet then referenced by the use of a formula or function. If the data is changed it will update all worksheets.
   • Benefits:
     • If one value is changed, it can be changed on all others.
     • Different displays can be used with different formats (individually coloured)
     • Can be hidden from other users. (Confidentiality)
       • Own access rights so authorised people can view, change or amend data.
     • A master worksheet can be created which pulls values from individual worksheets. -> create summary of key data.
     • Charts -> summarise data. (Visual representation) -> easier to analyse and compare.

2. A workbook is a collection of worksheets, stored in a single file and given a single name.

   • Can contain links

3. Rows

   • Range of cells that go across the spreadsheet horizontally.
   • Identified by number e.g. row 1, row 5

4. Columns

   • Range of cells that goes down the spreadsheet (vertically).
   • identifies by letters e.g. column A

5. Cells

   • The individual boxes within worksheets.
   • Has a unique cell-reference e.g. A1, B2
   • Holds text, numbers and formulae.

6. Range

   • Group of selected cells adjacent or non-adjacent
   • e.g. B6:H6