Openoffice Calc issues

I was using Calc last night and was having two troubles. I couldn't get the default number buttons (percent, standard, dollar) to change to a different default. The solution was to use the stylist. I still haven't figured out how to make it give multiple results based on a number of values. I think the scenario function must be used.