In case you forget what your function is called, or if you wanted to see a list of the functions available from Google Spreadsheets, take a look here! You can even sort the list based upon type of function...
Hope this helps!
P.S. I think the video has basically forced Adam to respond! :) (Our resident mate!)