Infosys Analyst Interview Questions, Process, and Tips

VLOOKUP is a function in Excel that allows you to search and retrieve data from a table based on a specific criteria.

• VLOOKUP stands for Vertical Lookup

• It is used to search for a specific value in a table and return a corresponding value from a different column in the same row

• It requires four arguments: lookup value, table array, column index number, and range lookup (optional)

• It is commonly used in financial analysis a...read more

Pivot tables are used to summarize and analyze large datasets.

• Pivot tables allow users to group and aggregate data based on different criteria.

• They are commonly used in spreadsheet software like Microsoft Excel.

• Pivot tables can help identify trends and patterns in data.

• They can also be used to create charts and graphs for visual representation of data.

Sumif is a function in Excel that adds up values based on a given condition.

• Sumif is used to add up values in a range that meet a certain criteria.

• The function takes three arguments: range, criteria, and sum_range.

• The range is the set of cells to evaluate, criteria is the condition to be met, and sum_range is the cells to sum.

• For example, =SUMIF(A1:A10,">5",B1:B10) will add up all values in B1:B10 where the correspondi

Count if is a function used to count the number of cells in a range that meet a certain criteria.

• The function takes two arguments: the range of cells to count and the criteria to use for counting.

• The criteria can be a number, text, or logical expression.

• For example, =COUNTIF(A1:A10,">5") will count the number of cells in the range A1:A10 that are greater than 5.

• The function can also be used with wildcard characters, su...read more

My name is [Your Name].

• My name is [Your Name].

• I go by the name [Your Name].

• You can call me [Your Name].

I am choosing this job because of my passion for data analysis and problem-solving.

• I have always been fascinated by data analysis and enjoy finding patterns and insights.

• I have a strong analytical mindset and enjoy solving complex problems.

• I believe this job will allow me to utilize my skills and contribute to the success of the organization.

• I am excited about the opportunity to work with data-driven decision-making an...read more

I am expecting a challenging and rewarding role as an Analyst.

• I am expecting to work with data and perform analysis to provide insights and recommendations.

• I am expecting to collaborate with cross-functional teams to gather and analyze data from various sources.

• I am expecting to use analytical tools and techniques to identify trends, patterns, and opportunities.

• I am expecting to present findings and recommendations to ...read more