- 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
- 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
- a single page of a spreadsheet
- individual worksheets can be given names to help identify them.
4 of 5
- 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
Similar ICT resources: