Assistant Manager Analytics Interview Questions and Answers

VLOOKUP is used in Excel to search for a value in a table and return a corresponding value from another column.

• VLOOKUP stands for 'vertical lookup' and is used to search for a value in the first column of a table and return a value in the same row from a specified column.

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the first column of the range B2:D10 and return the va...read more

Pivot tables are used in data analysis to summarize and analyze large datasets in a structured format.

• Pivot tables are commonly used in Excel to organize and summarize data from a spreadsheet.

• They allow users to quickly analyze and compare large amounts of data by rearranging rows and columns.

• Pivot tables can be used to calculate sums, averages, counts, and other aggregate functions on data.

• They are helpful in identifying trends, patterns, and outliers in data sets.

• Pivot tabl...read more