Henkel Controlling interview questions

Two rounds of interviews after I got an email that my CV passed their check. The first one is with HR who was supportive and we have quite a pleasant phone call. Second one was with the line manager and I must say this is the worst interview I ever had. Before the interview, they asked me to do a take-home excel case study and said that it would be discussed in the interview. However, the interviewer eventually never discussed anything about that case which was a waste of my time. The way she conducted the interview was also pretty uncomfortable as her approach made it more of an interrogation rather than a discussion. Questions kept on coming based on my CV which is quite basic but the way she phrased it was quite condescending. Eventually, a day after I got an email from HR that her feedback for me was that I lacked the knowledge and passion for this role.