Citi Interview Question

What are these functions used for in Excel - Pivot tables, VLOOKUP, freeze frames?