Standard Chartered Bank interview question

What is a Pivot table? Which Excel functions you consider useful?