Mercer Process Champion Interview Questions and Answers

INDEX MATCH is the replacement of VLOOKUP.

• INDEX MATCH is more flexible and efficient than VLOOKUP.

• It can search for values horizontally and vertically.

• It can also search for values in any column, not just the first column.

• It can handle multiple criteria with ease.

• Example: =INDEX(B2:B10,MATCH(E2,A2:A10,0))

• Example: =INDEX(B2:E10,MATCH(1,(A2:A10=G2)*(B2:B10=H2),0),4)

Slicer is used to filter data within a visual, while filter is used to filter data across multiple visuals.

• Slicer is a visual object that allows users to filter data within a single visual.

• Filter is a feature that allows users to filter data across multiple visuals in a report.

• Slicer is used to slice data based on a specific field or column.

• Filter is used to filter data based on specific criteria or conditions.

• Slicer i...read more