For some reason, when gnumeric is initially used all the plugins are disabled. This means that none of the functions are available! Go to Tools -- Plugins menu item, and then hit the button `Activate all'.