What is the use and purpose of Excel Pivot Table, VLOOKUP, HLOOKUP, SUMIF, and Index Match?

● Pivot Table is an interactive way to quickly summarize large amounts of data. It is used to summarize, sort, reorganize, and group. It allows us to extract the significance from a large, detailed data set. ● VLOOKUP: It is a function that makes Excel search for a certain value in a column, to return…...

To get access, please buy CA Interview Question Bank
Scroll to Top