Bajaj Finance MIS Executive Interview Questions, Process, and Tips

VLOOKUP is a function in Excel that allows you to search for a value in a column and return a corresponding value from another column.

• VLOOKUP stands for vertical lookup.

• It is commonly used to find specific data in large datasets.

• The formula takes four arguments: lookup value, table array, column index number, and range lookup.

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D...read more

A pivot table is a data summarization tool used in spreadsheet programs to organize and analyze large amounts of data.

• Pivot tables allow users to quickly summarize and analyze data from different perspectives.

• They can be used to group and aggregate data based on different criteria.

• Pivot tables provide flexibility in rearranging and reorganizing data to gain insights.

• They help in identifying patterns, trends, and outlie...read more

Duplicate values can be removed using various methods.

• Use a hashset to store unique values and remove duplicates

• Sort the array and remove adjacent duplicates

• Use a loop to compare each element with all other elements and remove duplicates

• Use the distinct() method in LINQ for C#

• Use the set() method in Python

IF formula is used to test a condition and return a value based on the result.

• Syntax: =IF(condition, value_if_true, value_if_false)

• Example: =IF(A1>10, "Yes", "No")

• Nested IF statements can be used for multiple conditions.