Econz interview question

Explain how vlookup, pivot table works