First, I submitted my resume to the recruiter. Then, I was selected for a first interview round with an engineer. I had to solve a programming exercise, and I could choose the programming language. I was also asked several questions about my background.

Next, I was chosen for the final round. In this round, I performed four interviews with different engineers from different departments. In each interview, I had to solve a programming task on paper or work through a testing and diagnostic scenario. I was also asked questions about my interests, expertise, and background. The programming tasks involved graphs, searching, and string processing.

In general, the interviewers were nice and kind. At the end, I was asked if I was willing to work in the Office team. Since I prefer software projects with hardware involvement, I said it would be okay, but I'd rather be involved in the Xbox or Windows Phone teams. I think that cost me the offer, but the experience was good overall.

How would you test this Excel function?