MIS and Operations Executive Interview Questions and Answers

VLOOKUP, INDEX-MATCH, and Pivot Tables are essential Excel functions for data analysis and reporting.

• VLOOKUP is used to search for a value in the first column of a range and return a value in the same row from a specified column.

• INDEX-MATCH is an alternative to VLOOKUP that combines the INDEX and MATCH functions to perform a lookup.

• Pivot Tables are used to summarize, analyze, explore, and present data in a tabular format.

• Formulas in Excel are used to perform calculations on d...read more