SFA's don't know excel anymore?!

Senior Financial Analyst here for a Corporate FP&A global team role. We had an assessment to weed out people who have no excel skils (pivot tables, large data sets, formulas), but even overqualified candidates would bomb them. How did these people even get their roles to begin with?! I understand someone from accounting may not know excel in the capacity we utilize, but these are ppl in finance roles to begin with. Am I overreacting on this? I've only been with one company so I am not sure how it is everywhere else.

How many of you do not create pivots from scratch, create summaries with data links, or do currency conversions?