Indus Towers SCM Coordinator Interview Questions and Answers

Vlookup is a function in Excel used to search for a value in the leftmost column of a table and return a corresponding value from another column.

• Vlookup stands for vertical lookup.

• It is commonly used for data analysis and manipulation in Excel.

• The function requires four parameters: lookup value, table array, column index number, and range lookup.

• It is useful for finding specific information in large datasets.

• Example: =...read more

A pivot table is a data summarization tool used in spreadsheet programs to organize and analyze large amounts of data.

• A pivot table allows users to rearrange and summarize data from a spreadsheet or database.

• It provides a way to group and aggregate data based on different criteria.

• Users can easily create customized reports and perform data analysis using pivot tables.

• Pivot tables are commonly used in data analysis, bus...read more