Pergunta de entrevista da empresa Frost & Sullivan

Explain the difference between VLOOKUP, SUMIF and INDEX-MATCH in Excel.