MIS Executive and Executive Team Lead Interview Questions and Answers

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 the lookup value is not found, Vlookup returns an error

• Vlookup can only return a value from a column to the right of the lookup column

MIS stands for Management Information System. Its purpose is to provide relevant information to management for decision-making.

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

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

• MIS helps in monitoring and controlling business operations.

• It improves communication and collaboration among different departments.

• Examples of MIS include ERP systems, CRM systems, and Business Intelligence tools.