List of spreadsheet functions

We will use the comments to this post to keep track of the various spreadsheet functions we will use in class over the course of the semester.

You will be asked to post a comment briefly summarizing a spreadsheet function at sometime during the semester (which will earn you a point towards your course participation grade).

You should post the given spreadsheet function and a short summary and/or example of what it does; this can be taken directly (or preferably adapted) from the built-in documentation (see my first comment below for an example).