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?
