They make you do an excel print out of excel functions right in front of them. Also they give you a test where you need to read very carefully. Arrange alphabetically in this specific area. They won't tell you what the test is about.
I think the key in generic questions like this is to be careful to cover the fundamentals, and to be familiar with all the followups so you're prepared for whatever they throw at you. Maybe do a mock interview with a Fujitsu Data Analysis expert on PrepTick to get a real-world answer? They give lots of guidance and pro tips on how to deal with this kind of stuff. https://www.preptick.com/practice-interviews-swe
It was not a big deal, I comfortably answered the questions however the senior guy were always trying to pick out things in the middle of my answers to know if I'm lying or not. They actually carefully go through every single line in your resume and ask you how did you do that and want you to explain. The senior guy was quite aggressive and not so nice as oppose to the other person who was completely new to the company. The recruiter told me the interview was good but they needed someone more professional in this area.