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.
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.
The questions were all related to your resume. What have you done in past jobs? What was your contribution at work? What problem you faced in your last job? They will ask your all former experience till now.
I answer them quite well. I was very happy after giving interview. Hoping to come in the second round. But didn't get called for the second round. When I asked them by email, about second round they gave my interview feedback. I was shocked as the job was not demanding and the interview went well. But always you will get feedback like you have to say like this or that. Finally, you cannot make everyone happy. It's their decision to take you or not to take you. Remember, never talk about technologies with the manager. They don't care about it. Give them only an overview and talk like manager too.