Senior MIS Analyst Interview Questions and Answers

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

Tally is an accounting software used for managing financial transactions like purchases, sales, and invoicing.

• To create a Purchase Account: Go to 'Accounts' > 'Create' > 'Ledger' and select 'Purchase Account'.

• For Sales Account: Similar to Purchase, navigate to 'Accounts' > 'Create' > 'Ledger' and select 'Sales Account'.

• Journal Entries: Use 'Accounting Vouchers' > 'F7: Journal' to record transactions not involving cash or bank.

• Credit Notes: Go to 'Accounting Vouchers' > 'F8: C...read more

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 pivot tables.

• Excel also offers other report formats such as ...read more

I would give myself a 9 out of 10 for Excel proficiency.

• I am highly skilled in Excel and can perform complex tasks efficiently.

• I have experience in creating pivot tables, charts, and graphs.

• I am proficient in using Excel functions such as VLOOKUP, SUMIF, and COUNTIF.

• I am familiar with macros and VBA programming in Excel.

• I am constantly learning and improving my Excel skills.

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 and models.

• Examples: ERP, CRM, SCM, Business Intelligence, ...read more