Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work.

A cell address formatted as an absolute reference doesn't change when you copy and paste it to other parts of your worksheet, enabling you to easily apply it to the entire column.