0 of 46 lessons complete.
Module 3: References · Lesson 16 of 46
Relative References
See how references shift when you copy a formula.
Step 1 of 20%
Stress equals force divided by area. In C2, divide A2 by B2.
Target: C2
C2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Force (N) | Area (m²) | Stress (Pa) | |||
| 2 | 5000 | 0.25 | ||||
| 3 | 7500 | 0.5 | ||||
| 4 | 12000 | 0.4 | ||||
| 5 | 9000 | 0.3 | ||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $