Pergunta de entrevista da empresa eClerx

What is the difference between VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP? How do you use Pivot Tables for data summarization? What are some Excel functions used for cleaning data How do you remove duplicates in Excel?