|My Favourite Functions in Spreadsheets
There are actually some useful functions for everyday use in a spreadsheet. Nothing fancy like solvers or pivot tables. Simple functions that can make everyday work easier. For everyday tasks.
I can only speak for Microsoft Excel - but I'm sure almost every calculation program has these functions in a similar way.
Everything listed via the four links in the Navigation Bar is based on spreadsheets not using the R1C1 reference style. In the unlikely event of being interested in this hilarious subject, there's a downloadable zip-file with more examples listed below.
The Examples file should display all functions in the respective language of the MS Excel version used.