ICICI Bank MIS Executive Interview Questions and Answers

Yes, vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• Vlookup stands for 'vertical lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

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

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the val...read more

Yes, pivot tables are used in Excel to summarize and analyze data.

• Pivot tables are used to summarize large amounts of data in Excel.

• They allow users to reorganize and summarize selected columns and rows of data.

• Users can easily create different views of the data by dragging and dropping fields.

• Pivot tables can also perform calculations and display results in a clear and organized manner.

• For example, you can use a pivot...read more

Vlookup is a function used to search for a specific value in a table and return a corresponding value from another column.

• Vlookup is commonly used in Excel to match data from different sources.

• It requires a unique identifier to match the data.

• The function can be used to extract data from large datasets quickly and accurately.

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

• Example: VLOOKUP(A2, '...read more

I am an experienced MIS Executive with a strong background in data analysis and management.

• I have a Bachelor's degree in Management Information Systems.

• I have worked for 5 years in a multinational company as an MIS Executive.

• I am proficient in using various data analysis tools such as Excel, SQL, and Tableau.

• I have successfully implemented data-driven strategies to improve operational efficiency and decision-making.

• I h...read more

Macros are used to automate repetitive tasks in software applications.

• Macros are sets of instructions that can be recorded and played back to automate tasks.

• They are commonly used in spreadsheet applications like Microsoft Excel to automate data manipulation and formatting.

• Macros can also be used in programming languages like VBA (Visual Basic for Applications) to automate tasks in software applications.

• They can save t...read more

One issue facing our operation is supply chain disruptions due to global events.

• Global events such as natural disasters, political unrest, or pandemics can disrupt the supply chain.

• Shortages of raw materials or components can lead to production delays.

• Increased transportation costs and logistics challenges can impact the timely delivery of goods.

• Finding alternative suppliers or diversifying the supply chain can help mi...read more

One common issue facing billing is delayed payments from clients.

• Delayed payments from clients can cause cash flow issues for the company.

• Inaccurate billing can lead to disputes and delayed payments.

• Lack of communication between billing department and clients can result in misunderstandings.

• Implementing automated billing systems can help streamline the process and reduce errors.