What are some array sorting methods you've used in VBA? What is the most optimal way to transpose arrays onto a worksheet? What is the default variable type of an undeclared variable in VBA? When would you use credit spreads? What option pricing methods do you know? What are their inputs? What is a swap? A bond? Duration? Are you familiar with volatile functions? Have you used VLOOKUP? INDEX? What is the difference between the two?

1st round : Architecture of my current product, C++ question, design patter implementation, coding problem for in place update of binary searct tree to linked list. 2nd round : Design a system to generate the given output after reading data through the file. Design was discussed for one hour 3rd round : product lead discussed previously asked design questions and gave information about the project