TD Manager interview questions

The position must require expertise in the Microsoft Office Suite of applications because I was asked if I used formulas and what formulas I typically used. Excel is second nature to me so I couldn't grasp if I was being asked if I used VLookup or =MID. It was an entry level question I wasn't prepared for. I just said I used whatever I needed, whether that was a formula or a macro or a pivot table; maybe it's an Access Database. I just use whatever I need to collect or aggregate data in order to answer a question, solve a problem or present results.