Maybe not annoyances but ways of getting things done.
Your spreadsheet has a column with dates, say A7 has 1/2/2019 and you want to replace the dates in the rest of the column with the next year, e.g., 2020.
It's easier to name a cell so that (a) references make sense and (b) you can move the cell but retain the reference.
for example referencing payment totals when adding/deleting rows/columns around them.
How to name a cell
Alternatively you can select the cell, Sheet > Named Ranges and Expressions > Define
How to use a named cell
Note that names can be used within formulas.