Spreadsheet Concepts

characteristics of modelling software
1. used to model objects
  1. virtual representation
  2. use of layers
  3. questions can be asked
2. used for financial modeling
  1. based on functions and formulae
  2. variables and constants can be used
  3. what-if questions can be asked
variables, formulae, rules and functions
1. variable - identifier asociated with a particular cell which contains a value
2. a formula is a calculation which uses numbers, addresses or cells and mathematical operators
3. rules are a set of procedures that must be followed and can also be the sequence of events required for a calculation to work
4. a function represents a complex formula that uses reserved words
worksheets, workbooks, cells, rows, columns, ranges
1. worksheets consists of all the cells in the sheet
2. workbook is a collection of work sheets
3. row is a range of cells denoted by a number that go across the worksheet
4. column is a range of cells denoted by a letter that go down the worksheet
5. range is a group of cells denoted by a name or cell references
absolute and relative referencing
1. relative - the cell referenced in a formula changes when the formula is copied to other cells
2. absolute - teh cell referenced in the formula remains exactly the same when the formula is copied to other cells

Resource summary

	Created by eleanorbradbury over 11 years ago