Lenskart MIS Executive Interview Questions and Answers

MS Excel is a spreadsheet software developed by Microsoft for organizing, analyzing and manipulating data.

• MS Excel allows users to create and edit spreadsheets with formulas and functions

• It can be used for data analysis, budgeting, financial modeling, and more

• Excel also offers features like charts, graphs, and pivot tables to visualize data

• It is widely used in business, finance, and accounting industries

• Examples of Exc...read more

There are different types of MX Excel, including MX Excel 2007, MX Excel 2010, and MX Excel 2013.

• MX Excel 2007: Released in 2007, it introduced the ribbon interface and new file formats.

• MX Excel 2010: Released in 2010, it added new features like Sparklines and Slicers.

• MX Excel 2013: Released in 2013, it focused on improving collaboration and introduced new functions like Flash Fill.

A pivot table is a data summarization tool used in spreadsheet programs like Excel.

• It allows users to quickly summarize and analyze large amounts of data.

• Users can group data by different categories and perform calculations on the summarized data.

• Pivot tables are useful for creating reports and visualizations based on complex data sets.

• For example, a sales team could use a pivot table to analyze sales data by region, p

Excel sheet is a spreadsheet program used for organizing, analyzing and storing data.

• It is a software application developed by Microsoft.

• It allows users to create and manipulate data in rows and columns.

• It can perform calculations, create charts and graphs, and analyze data.

• It is commonly used in business, finance, and accounting.

• Examples include budgeting, inventory management, and sales tracking.

Supply chain management involves the coordination and optimization of all activities involved in the sourcing, procurement, production, and logistics of a product or service.

• Involves planning, sourcing, making, delivering, and returning products or services

• Focuses on efficiency, cost reduction, and customer satisfaction

• Requires collaboration with suppliers, manufacturers, distributors, and customers

• Utilizes technology ...read more

Computer hardware refers to the physical components of a computer system.

• Examples include the motherboard, CPU, RAM, hard drive, and graphics card.

• Hardware can be classified as input devices (e.g. keyboard, mouse), output devices (e.g. monitor, printer), and storage devices (e.g. hard drive, flash drive).

• Hardware can also be categorized as internal (e.g. motherboard, CPU) or external (e.g. monitor, keyboard).