From all the literature I've encountered, cardiovascular exercise is the most important for those in a sedentary lifestyle. Weight training is important too, but it's not a replacement for cardio.

Anecdotally, the fittest elders I meet who do office work are those who run and cycle or do other cardio activities.