Cognizant interview question

Tell me about V-Look Up and Pivot Table in MS Excel?