Consumer confidence has picked up and is suggesting the worst of the economic downturn may be coming to an end, a survey shows.