Probus Insurance Broker Private limited Interview Questions and Answers

VLOOKUP formula searches for a value in the first column of a table and returns a corresponding value in the same row.

• Select the cell where you want to enter the formula

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

• Replace lookup_value with the value you want to look up

• Replace table_array with the range of cells that contains the data

• Replace col_index_num with the column number of the data you ...read more

Using INDEX-MATCH function and replacing date format in Excel sheet.

• Use INDEX-MATCH function to lookup values in a table

• Syntax: =INDEX(array, MATCH(lookup_value, lookup_array, [match_type]))

• Replace date format using the Format Cells option

• Select the cell(s) with the date, right-click and select Format Cells

• Choose the desired date format from the Number tab