Management Information System Executive Interview Questions and Answers

To close a Trouble Ticket (TT) after resolving a fiber cut, update the ticket status, document the resolution, and notify stakeholders.

• Update the TT status to 'Resolved' or 'Closed' in the ticketing system.

• Document the details of the fiber cut resolution, including steps taken and time taken to resolve.

• Notify stakeholders such as the customer, network operations team, and management about the resolution.

• Close the TT only after confirming that the fiber cut issue has been comp...read more

I have a good understanding of advanced Excel formulas.

• I am proficient in using functions like VLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, etc.

• I can create complex formulas using logical and mathematical operators.

• I am familiar with array formulas and how to use them.

• I have experience in using Excel's built-in functions and creating custom functions.

• I can use Excel's data analysis tools like PivotTables and PivotCharts.

• I am constantly learning and keeping up with new features and u...read more

Team coordination can be effectively managed through clear communication, setting goals, assigning roles, fostering collaboration, and providing feedback.

• Establish clear communication channels to ensure everyone is on the same page

• Set specific goals and objectives for the team to work towards

• Assign roles and responsibilities based on individual strengths and expertise

• Encourage collaboration and teamwork by promoting open communication and idea sharing

• Provide regular feedback ...read more

Pivot tables are used in Excel to summarize and analyze data, allowing users to reorganize and display information in a more meaningful way.

• Pivot tables help in summarizing large amounts of data quickly and efficiently.

• They allow users to easily rearrange and filter data to analyze trends and patterns.

• Users can create custom calculations and group data based on specific criteria.

• Pivot tables are commonly used in business and finance for budgeting, forecasting, and data analys...read more