The Excel RAND function returns a random number between 0 and 1. For example, =RAND() will generate a number like 0.422245717. RAND recalculates when a worksheet is opened or changed.
The cost to furnish your new home is up to you. Do you have a champange taste or do you prefer the college dorm look? It is up to you. There is a store called Rooms To Go that has preselected room packages for about $2500-$3500.
As for cost per sq ft, there are so many factors. It can likely range from $100 to thousands, depending on what you want, how much work you do yourselves, etc, but a general rule of thumb is about $250-$400 for a nice house.