Ingest Executive Interview Questions and Answers

Merging and unmerging cells in Excel and using VLOOKUP function.

• To merge cells, select the cells and click on the 'Merge & Center' button in the Home tab.

• To unmerge cells, select the merged cell and click on the 'Merge & Center' button again.

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

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

• Example: =VLOOKUP(A2, B2:C10, 2, FALSE) will search f...read more