Bajaj Finserv MIS Coordinator Interview Questions and Answers

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

• Open Excel and select the cell where you want the result to appear

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

• lookup_value is the value to search for

• table_array is the range of cells containing the data

• col_index_num is the column number in the table_array from which to ret...read more

Pivot can be applied in Excel to summarize and reorganize data.

• Select the data you want to pivot

• Go to the 'Insert' tab and click on 'PivotTable'

• Choose where you want the PivotTable to be placed

• Drag and drop fields into the 'Rows', 'Columns', and 'Values' areas to organize the data

• Apply filters and formatting as needed