Genentech Interview Question

What is a pivot table and how would you use one?