Spreadsheet Concepts

Spreadsheet Concepts

1. Absolute and cell reference

2. Object Modelling

   • An object model is a virtual representation of an object that can be created on a computer
   • Commonly used to show cars before they are made
   • Shows different layers/ views of the object.

3. Variables, Formulae, Functions and rules

   • Variables are identifiers that are associated with a specific cell
   • Formulaes are the way that a calculation is represented in a spreadsheet. Formulaes use numbers, address of cells and different mathematical operations
   • Functions are used to represent a formula which is too complex or long for a normal user to enter
   • Rules are a set of procedure that must be followed. A Rule can be a sequence of events where it is needed to be able to do a specific calculation

4. Work sheets, Work books, Rows, Columns, Cells and range

5. Financial Modelling

   • Financial modelling is a mathematical object which has been created to show financial assets. Spreadsheets are based on a lay out of rows and columns which means that it can help assist someone who wishes to model their finance
   • Safer and cheap to use
   • Features like What if statements can be used

6. Validations