Amazon Business Analyst interview questions

The process was highly disappointing for a company such as Amazon. I applied on the website, and was quickly invited to do a simple test on business skills. The HR representative then contacted me to schedule a phone interview, and that's when it went off tracks. She delayed several times the interview, sometimes by warning me one hour before, sometimes by sending me an email with a false excuse 3 or 4 hours later. When I finally passed it I was invited to do another Excel test and 3 interviews. The interviews went great but the HR woman came back to me (2 days later than she was supposed to, after I sent her several emails because I needed the answer quickly) to tell me that I didn't get the internship because I had failed the Excel test and hadn't a profile "analytical enough" for the job. While I have no problem accepting that I wasn't the right one for this position, I talked intern currently occupying the position and he didn't knew anything about excel at the beginning of the internship. Whereas I am an engineer (which is quite rare for this kind of positions), and know how to use Excel perfectly, even VBA, and how to make SQL requests in a database. The decision just didn't make any sense, and I am very happy to go elsewhere.