worksheets, workbooks, rows, columns, cells and range

notes on the above for chapter 4 ocr AS IT

?

worksheet

  • large grid of cells on a single sheet
  • can be given names
  • single page in a workbook
1 of 6

workbook

  • collection of worksheets that make up one spreadsheet
  • contains all information whilst worksheets contain information about a specific area
  • can be given different access rights to each worksheet or different areas of a spreadsheet
2 of 6

rows

  • range of cells that run horizontally across the spreadsheet
  • indentified by numbers
  • if a row is deleted then it is automatically renumbered
  • rows can be hidden from the user
3 of 6

columns

  • range of cells that run vertically down the page
  • identified by letters
  • if a column is deleted then it is relettered automatically
  • columns can be hidden from the user
4 of 6

cell

  • data store- holds data
  • identified by the row and column they are in such as D4
  • each cell has a unique address and can be given names to identify them
  • each cell can be formatted individually (background colour, font, text size etc.)
  • conditional formatting can be applied, the format of a cell changes if the contents meets certain requirements. for example, if a number is entered as negative then it turns red
5 of 6

Range

  • group of cells
  • identified by cell references and name
  • given from top left to bottom right of the page
  • ranges that contain similar data are used in formulas and functions
6 of 6

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »