From ACT Wiki
(Difference between pages)
Jump to navigationJump to search
imported>Doug Williamson |
imported>Doug Williamson |
Line 1: |
Line 1: |
| 1. ''Measurement.''
| | Special Drawing Rights. |
| | |
| A relative measure is one expressed as a proportion or percentage, rather than in money terms or other fixed terms.
| |
| | |
| | |
| 2. ''Financial modelling - spreadsheets - construction - cell references.''
| |
| | |
| In financial modelling with spreadsheets, relative refers to cell references when they're copied around the spreadsheet.
| |
| | |
| An example of a relative cell reference in Excel is '''A1.'''
| |
| | |
| | |
| When a relative cell reference is copied to other parts of the spreadsheet it will change in such a way as to maintain the ''relative'' difference in the positions of the referenced cell, and the cell pointing to it.
| |
| | |
| Relative cell references are the default.
| |
| | |
| | |
| By contrast, fully absolute cell references - for example '''$A$1''' in Excel - will stay as $A$1 wherever we copy them within the spreadsheet.
| |
|
| |
|
|
| |
|
| == See also == | | == See also == |
| * [[Absolute]] | | * [[Special drawing rights]] |
| * [[Default]]
| |
| * [[Excel]]
| |
| * [[Financial modelling]]
| |
| * [[Relative value]]
| |
| * [[Spreadsheet]]
| |
| | |
| [[Category:The_business_context]]
| |
| [[Category:Identify_and_assess_risks]]
| |
| [[Category:Manage_risks]]
| |
| [[Category:Risk_frameworks]]
| |
| [[Category:Risk_reporting]]
| |
| [[Category:Technology]]
| |
Revision as of 06:47, 1 April 2016
Special Drawing Rights.
See also