10+ Deloitte Interview Questions and Answers

The SUBSTITUTE function in Excel replaces a specific occurrence of a text string with another text string.

• Syntax: SUBSTITUTE(text, old_text, new_text, instance_num)

• text: The original text string where replacement will occur

• old_text: The text string to be replaced

• new_text: The text string to replace old_text with

• instance_num: Optional parameter to specify which occurrence of old_text to replace

• Example: =SUBSTITUTE("apple,banana,orange", ",", "/", 2) will replace the second com...read more

A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.

• Accessed by selecting the data range you want to analyze, then going to the 'Insert' tab and clicking on 'PivotTable'.

• Utilized by dragging and dropping fields into the 'Rows', 'Columns', 'Values', and 'Filters' areas to organize and summarize data.

• Can be used to quickly analyze large datasets and identify trends, patterns, and relationships within ...read more

Tableau and Power BI are both powerful data visualization tools, with Tableau being more user-friendly and Power BI offering better integration with Microsoft products.

• Tableau is known for its user-friendly interface and ease of use for creating visually appealing dashboards.

• Power BI offers better integration with Microsoft products such as Excel, SharePoint, and SQL Server.

• Tableau is considered superior for its ease of use and flexibility in creating complex visualizations, ...read more

To sort the top 10 rows in Excel, select the range of data, go to the Data tab, click on Sort, choose the column to sort by, select Top 10 from the options, and specify whether to sort in ascending or descending order.

• Select the range of data containing the top 10 rows you want to sort.

• Go to the Data tab in Excel.

• Click on the Sort button.

• Choose the column you want to sort by.

• Select 'Top 10' from the 'Sort On' dropdown menu.

• Specify whether you want to sort in ascending or desc...read more

Adjusted R-squared is a statistical measure that adjusts the R-squared value for the number of predictors in a regression model.

• Adjusted R-squared takes into account the number of predictors in a regression model, providing a more accurate measure of the model's goodness of fit.

• It penalizes the addition of unnecessary predictors, helping to prevent overfitting.

• A higher adjusted R-squared value indicates a better fit of the model to the data.

• It is calculated using the formula:...read more

Correlation is a statistical measure that describes the relationship between two variables.

• Correlation can range from -1 to 1, with 0 indicating no correlation, 1 indicating a perfect positive correlation, and -1 indicating a perfect negative correlation.

• A positive correlation means that as one variable increases, the other variable also tends to increase. For example, there is a positive correlation between studying hours and exam scores.

• A negative correlation means that as ...read more

Project managers focus on overseeing the execution of a specific project, while product managers are responsible for the overall strategy and development of a product.

• Project managers are focused on the successful completion of a project within scope, budget, and time constraints.

• Product managers are responsible for the strategic direction, development, and success of a product throughout its lifecycle.

• Project managers work with cross-functional teams to ensure project milest...read more

Limitations of food delivery apps that need improvement

• Inaccurate delivery times leading to customer dissatisfaction

• Limited restaurant options available on the app

• Difficulty in customizing orders or making special requests

• Issues with order accuracy and missing items

• Lack of transparency in pricing and additional fees

Family income can be derived from both a business and job holders.

• Family income can come from a business owned by a family member.

• Family income can also come from salaries earned by family members from their jobs.

• In some cases, family income may be a combination of income from both business and job holders.

• Examples: A family may own a small business like a bakery and also have family members working in corporate jobs.

• Another example could be a family where one member runs a c...read more