Cell References: Relative, Absolute & Mixed (8 Examples)

Topics: Formula Elements, Formula Types and Cell References, Assumption Tables/Formula Elements, and Scenario Manager

Topics in this video:
1. Relative Reference Example, Net Income Formula (01:09 min)
Ctrl + Enter to populate a range of cells with a formula (02:02 min)
2. Relative and Absolute Reference Example, Increase Price Formula (02:20 min)
Ctrl + Period ( . ) to jump to each corner of a highlighted range (04:29 min)
3. Relative and Absolute Reference Example, Commission Formula (05:00 min)
4. A. Relative and Absolute Reference Range Example, SUMIFS formula for adding with one condition. Top of sheet CR(4). (05:51 min)
5. Mixed Cell Reference Example, Income Statement Budget Example (07:56 min)
6. Mixed Cell Reference Example, Multiplication Table Example (19:23 min)
4. B. Mixed Cell Reference Example, Cross Tabulated Table with SUMIFS formula for adding with two conditions (criteria). Bottom of sheet CR(4). (22:47 min)
7. Mixed Cell Reference Example, Future Value (Value of pension example) (28:34 min)