AS IT using spreadsheets OCR

notes on different parts of spreadsheets.

HideShow resource information

cell

  • a cell is a data store which hold bits of data
  • they can be named after the row and column they are in
  • every cell in the spreadsheet has a unique address they can also have names like RATE_VAT
  • each cell can be formatted individually, so things like font size and colour, and style, borders, alignment and validation can be changed in each cell
  • conditional formatting, when the format of a cell is changed if the contents meet certain conditions, so if a number is negative it can be set to turn red.
  • cells can be protected with a password
1 of 5

Rows and columns

  • rows are identifyed by numbers and run down the sheet
  • columns are identified by letters and run across the sheet
  • if a row/ column is inserted or removed they are re numbered or relettered automatically
  • rows and columns can be hidden from the user, e.g if the rows hold calculations that the user doesn't want to see.
2 of 5

Range

  • a range is a group of cells that can be identifed bt the cell references or name
  • range is given by the top left cell to the bottom right e.g B2:D6
  • ranges contain similar data and are used in formulas and functions
  • the same formatting can be applied to a range of cells, which means cells can be formatted quicker than just doing it one at a time
3 of 5

worksheet

  • a single page of a spreadsheet
  • individual worksheets can be given names to help identify them.
4 of 5

workbooks

  • a workbook is a collection of worksheets which make up one spreadsheet document
  • a workbook contains all information whereas a workshhet contains information about one specific area or topic
  • for example, a business may have 4 sales regions each one could be contained in a worksheet, with the workbook containing all the information about the business.
  • each worksheet can be given different access rights eg, one worksheet ay contain information that would be avalible to the manager only.
5 of 5

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »