Worksheets, workbooks, rows, columns, cells and ranges

A worksheet is a single sheet (page) of rows and columns in a workbook.
1. 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.
2. Benefits:
  1. If one value is changed, it can be changed on all others.
  2. Different displays can be used with different formats (individually coloured)
  3. Can be hidden from other users. (Confidentiality)
    1. Own access rights so authorised people can view, change or amend data.
  4. A master worksheet can be created which pulls values from individual worksheets. -> create summary of key data.
  5. Charts -> summarise data. (Visual representation) -> easier to analyse and compare.
A workbook is a collection of worksheets, stored in a single file and given a single name.
1. Can contain links
Rows
1. Range of cells that go across the spreadsheet horizontally.
2. Identified by number e.g. row 1, row 5
Columns
1. Range of cells that goes down the spreadsheet (vertically).
2. identifies by letters e.g. column A
Cells
1. The individual boxes within worksheets.
2. Has a unique cell-reference e.g. A1, B2
3. Holds text, numbers and formulae.
Range
1. Group of selected cells adjacent or non-adjacent
2. e.g. B6:H6

Resource summary

	Created by charcrawford over 10 years ago