Pergunta de entrevista da empresa Flagstar Bank

Do you know how to use VLOOKUP and pivot tables?