Axis Bank Interview Questions and Answers

To resolve high temperature at site, check cooling systems, airflow, and environmental factors.

• Check cooling systems for any malfunctions or blockages

• Ensure proper airflow in the site to prevent overheating

• Consider environmental factors such as weather conditions or ventilation

• Implement temperature monitoring systems for early detection

• Schedule regular maintenance checks for cooling equipment

There are multiple criteria functions in Excel such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, etc.

• Excel has various criteria functions like SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, etc.

• These functions allow you to perform calculations based on specified criteria.

• For example, SUMIF function adds the cells specified by a given condition or criteria.

• Another example is COUNTIFS function which counts the number of cells that meet multiple criteria...read more

Conditional formatting is used to visually highlight data based on specified conditions.

• Conditional formatting helps in easily identifying trends, outliers, and patterns in data.

• It can be used to highlight cells that meet certain criteria, such as values above or below a certain threshold.

• For example, in a sales report, you can use conditional formatting to highlight cells with sales figures below target in red.

• It improves data visualization and makes it easier to interpret a...read more

I communicate with clients through clear and concise emails, phone calls, and in-person meetings.

• Regularly update clients on the status of their network issues

• Provide detailed explanations of technical issues in non-technical terms

• Listen actively to client concerns and address them promptly

• Offer solutions and recommendations for improving network performance

• Schedule regular meetings to discuss ongoing projects and future plans

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• Use the VLOOKUP function in Excel to search for a value in the first column of a table and return a value in the same row from another column.

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

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and returns the value in the 3rd column

• Make sure the lookup value ...read more