Management Information System Executive Interview Questions and Answers

Updated 31 Jan 2025

Popular Companies

Q1. How do you close the Trouble Ticket (TT) on your end after a fiber cut has been resolved?

Ans.

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

Q2. How much you know about the formulla of advenced excel ??

Ans.

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

Management Information System Executive Interview Questions and Answers for Freshers

View all interview questions

Q3. How can team coordination be effectively managed?

Ans.

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

Q4. Use of Pivot Table

Ans.

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

Are these interview questions helpful?

Q5. Use of Vlookup.

Ans.

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 used to search for a value in the first 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) will search for the value in cell A2 in the range B2:D10 and return the value in the 3rd column
Vlookup is ...read more