LibreOffice Calc - Define Name
When you have a range of cells or a formula you use often, you can assign a name to it and use the name in place of the range or formula.
Spreadsheet files used in video available at:
http://panopia.com/libreoffice/