BNY interview question

How would you do X function in Excel? Describe a time when you X? Explain how you solved X situation?