42666
Description
Mind Map by green.george, updated more than 1 year ago
|
Created by green.george
about 11 years ago
|
|
Chapter 4
- Modelling
- Object
- E.g. Cars
Buildings
- E.g. Cars
Buildings
- Mathematical
- E.g. Financial
Spreadsheets
- WHATIF and GOALSEEK
used for finance predictions
- E.g. Financial
Spreadsheets
- Why modelling?
- Cheaper
- Easier
- Safer
- Can be edited
- Automatic
recalculation
- accelerated and
decellerated
- Backed up and shared
- Problems
- Real world has too
many variables
- model relates to people
which can be unpredictable
- Effective models are
time consuming to
create
- Real world has too
many variables
- Cheaper
- Object
- Spreadsheet
components
- Variable - linked to a formula
which can be changed
- Formulae - Calculations
in a spreadsheet
- Functions - Complex formulae
stored in worded commands
- Rules - procedure that must be
followed e.g. validation checks
- Variable - linked to a formula
which can be changed
- What if?
- Variables are
edited to change
the outcome
- Target outcome can
be set
- Useful for business
predictions/forecasts
- Variables are
edited to change
the outcome
- Spreadsheet Terms
- Worksheet -
individual tab
within a
spreadsheet
- Workbook -
collection of
worksheets
- Row - Horizontal
set of data
- Column - Vertical
set of data
- Cell - One individual box
which contains data
- Range - A
group of
cells e.g.
A5:C7
- Worksheet -
individual tab
within a
spreadsheet
- Cell referencing
- Absolute - when a cell is replicated the
absolute referencing will not change e.g. A$4$
- Relative - as the cell is replicated it will change
according to its relative position e.g. A4
- Absolute - when a cell is replicated the
absolute referencing will not change e.g. A$4$
Want to create your own Mind Maps for free with GoConqr? Learn more.