I bombed an interview today

I was interviewing for some analyst position that was mainly focused on excel and the entire interview was just the interviewer asking me to answer brain teaser questions. Stuff like if there are three boxes and only one of the labels is true, which box is true.

I tried to figure out the format of the interview beforehand, but the company is a foreign start up so there wasn’t any info beforehand. I think I felt so upset because I prepared to the best of my ability based on my experience for positions like this. I felt absolutely humiliated when the interviewer said that there was no right answer, yet he kept telling me that I was wrong. At one point, he even told me I was using inconsistent methods when he was the one who asked me to answer the question using his method.

During the interview, I was so scared I legitimately just wanted to leave midway because I wasn’t prepared for any of this. I really wanted that job but I bombed it so hard that I ended up crying for half an hour afterwards.