Excel

Its a pretty strong rule that a block of cells should have a name.

Its not so clear that each column should have a range name. If you do create the names in the column headings it can make formulas easer to understand. However, it does create a lot of names. If the names are similar to others, it becomes difficult to untangle them.