When I read articles like this, I tend to assume that they are exaggerations written by people who feel burned because they didn't get the job they want and that the reason was unfair interview questions.
In other words, I simply don't believe that interviewers are, as a group, so stupid that they regularly ask obscure Excel questions when they are plainly not relevant.
To continue with the recruiting example, I suspect what is more common is that interviewers are expecting candidates with some Excel experience, and ask questions to gauge some basic level of competency. And interviewees have conflated using it one time with any depth of experience.
I can attest to seeing this many times during programming interviews. If I see something towards the top of someone's resume, I will ask a basic question to see if anything whatsoever is known about that thing. Yes, book knowledge. Stuff that you would know if you had actually read any docs.
I don't want to work alongside someone who claims knowledge or experience of something and doesn't know the basics. Or doesn't know that they don't know the basics.