Review of keyboard shortcuts, freezing panes, SUM, AVERAGE, relative reference, absolute reference
0:00 Keyboard Shortcuts
3:20 Changing Rows and Freezing Panes
8:44 Relative and Absolute References
Note: F4 = Shortcut key for absolute reference (like $B$19)
- On a laptop, you may need to hold down fn (function) key first before clicking on F4. See below image for the location of fn key.
- If you have a Macbook Pro with a Touchbar, you need to hold down fn key to see the Function keys like F1, F2, etc. on your keyboard.
