Deloitte Interview Questions and Answers

Microsoft Excel is a spreadsheet program used for organizing, analyzing, and visualizing data.

• Used for creating spreadsheets with rows and columns

• Allows for data entry, calculations, and data analysis

• Can create charts and graphs to visualize data

• Commonly used in business for budgeting, forecasting, and data management

Create an employee salary sheet in Excel

• Open Excel and create a new spreadsheet

• Enter employee names in one column

• Enter corresponding salaries in another column

• Format the sheet for clarity and professionalism

• Save the file for future reference

I will create a pie chart showing the distribution of sales by product category.

• Collect data on sales for each product category

• Calculate the percentage of total sales for each category

• Use a pie chart to visually represent the distribution

• Label each slice with the corresponding product category

MS Word is a word processing software developed by Microsoft for creating, editing, and formatting documents.

• Word processing software by Microsoft

• Used for creating, editing, and formatting documents

• Includes features like spell check, grammar check, and templates

PowerPoint is a software program used to create presentations with slides containing text, images, videos, and animations.

• PowerPoint is part of the Microsoft Office suite.

• Users can create slideshows with various multimedia elements.

• It is commonly used for business presentations, educational purposes, and personal projects.

• Slides can be customized with different layouts, themes, and transitions.

• Presenters can use PowerPoint to deliver information in a visually appealing way.

I created a bar chart in Excel to visualize sales data for the past year.

• Open Excel and input the sales data into a spreadsheet

• Select the data range and click on the 'Insert' tab

• Choose 'Bar Chart' from the chart options and customize the chart as needed

My favorite color is blue.

• Blue is often associated with calmness and tranquility.

• It is a versatile color that can be both soothing and bold.

• Examples of shades of blue include navy, sky blue, and teal.