Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Only if the true distribution does not change significantly through time. e.g. time series data. You don't want to be validating today's economics with economics from the 1950s.
People without a business background don't use excel. Period. And considering business graduates don't usually go into data science, you can understand the ignorance.
Reading comprehension guys. "We are interviewing for a data scientist position...", meaning he's not the employer. It is a group intervew. He's just judging the other candidate being interviewed.