Rosmerta Technologies Senior MIS Analyst Interview Questions, Process, and Tips

MIS stands for Management Information System. It is a computer-based system that provides information to support decision-making.

• MIS collects, processes, and stores data from various sources.

• It generates reports and provides analysis to support decision-making.

• MIS helps in planning, controlling, and organizing business operations.

• Examples of MIS include ERP systems, CRM systems, and financial management systems.

MIS stands for Management Information System. There are mainly four types of MIS: Strategic, Tactical, Operational, and Decision Support System.

• Strategic MIS: Helps in long-term planning and decision-making.

• Tactical MIS: Helps in short-term planning and decision-making.

• Operational MIS: Helps in day-to-day operations and monitoring.

• Decision Support System: Helps in complex decision-making by providing analytical tools a...read more

Protect sheet from editing by setting password and restricting access.

• Set a password to protect the sheet

• Restrict access to the sheet by only allowing authorized users to edit

• Use Excel's Protect Sheet feature to prevent editing

• Use VBA code to protect the sheet and prevent unauthorized access

The constraint of a VLOOKUP function is that it can only look up values in the leftmost column of a table.

• VLOOKUP can only search for values in the first column of a table

• The lookup value must be in the leftmost column of the table

• If you need to search for values in other columns, you need to use INDEX/MATCH instead

There are several report formats available in MS Excel.

• Excel offers various report formats such as tables, charts, pivot tables, and pivot charts.

• Tables are used to organize data in rows and columns.

• Charts are used to visually represent data in different formats such as bar, line, and pie charts.

• Pivot tables are used to summarize and analyze large amounts of data.

• Pivot charts are used to visually represent data from pi...read more

To prepare an MIS report in Excel, follow these steps:

• Identify the data to be included in the report

• Organize the data in a structured format

• Use Excel functions and formulas to calculate metrics

• Create charts and graphs to visualize the data

• Format the report for readability and clarity

• Include a summary or conclusion section

• Save the report and share with relevant stakeholders