Data Tools & Data Management Questions

🔹 Data Tools & Data Management

Q1. What is Sorting in Excel?
Answer:
Sorting arranges data in ascending or descending order based on values.
👉 Example: Sorting employee names alphabetically or salaries from highest to lowest.

Q2. What is Filtering in Excel?
Answer:
Filtering allows you to hide unwanted data and display only specific records that meet certain conditions.
👉 Example: Show only “Sales > ₹50,000”.

Q3. What is Advanced Filter in Excel?
Answer:
Advanced Filter lets you filter data based on complex criteria and even copy the filtered results to another location.

Q4. What is Data Validation in Excel?
Answer:
Data Validation restricts what data can be entered in a cell.
👉 Example: Allow only numbers between 1 and 100.

Q5. What is the use of Drop-Down Lists in Excel?
Answer:
A drop-down list is created using Data Validation to let users select values from a predefined list instead of typing manually.

Q6. What is Remove Duplicates in Excel?
Answer:
This feature removes duplicate entries in a selected range of data while keeping only unique values.

Q7. What is the use of Text to Columns in Excel?
Answer:
It splits text into multiple columns based on a delimiter (like comma, space, or tab).
👉 Example: Split “First Last” into separate columns.

Q8. What is Flash Fill in Excel?
Answer:
Flash Fill automatically fills in values when it detects a pattern.
👉 Example: Extracting first names from full names.

Q9. What is Consolidate in Excel?
Answer:
Consolidate combines data from multiple ranges into a single summary table using functions like SUM, AVERAGE, etc.

Q10. What is What-If Analysis in Excel?
Answer:
What-If Analysis is used to test different scenarios in data. Tools include:

Scenario Manager
Goal Seek
Data Tables

Q11. What is Goal Seek in Excel?
Answer:
Goal Seek is used to find the input value required to achieve a specific result.
👉 Example: Find the sales needed to reach ₹1,00,000 revenue.

Q12. What is the Scenario Manager in Excel?
Answer:
Scenario Manager allows you to create and compare multiple “what-if” scenarios in a worksheet.

Q13. What is the use of Data Tables in Excel?
Answer:
Data Tables show how changing one or two variables affects the result of a formula. Commonly used in financial modeling.

Q14. What is the difference between Relative and Absolute References in Data Tools?
Answer:

Relative Reference (A1): Changes when copied.
Absolute Reference ($A$1): Remains fixed.

Q15. What is Freeze Panes in Excel?
Answer:
Freeze Panes locks rows or columns so they stay visible while scrolling.
👉 Example: Keeping header row fixed at the top.

Q16. What is Split Window in Excel?
Answer:
Split divides the worksheet into multiple panes so you can view different parts of the sheet simultaneously.

Q17. What is the difference between Hide and Group in Excel?
Answer:

Hide: Temporarily hides rows/columns.
Group: Lets you collapse/expand sections of rows or columns.

Q18. What is the Subtotal function in Excel?
Answer:
Subtotal summarizes data with functions like SUM, AVERAGE, COUNT, etc., applied to filtered groups of data.

Q19. What is a Pivot Table?
Answer:
A Pivot Table is a powerful tool that summarizes, analyzes, and rearranges large data sets. It can group, filter, and display totals quickly.

Q20. What is the difference between a Pivot Table and a Normal Table?
Answer:

Normal Table: Displays data as entered.
Pivot Table: Summarizes and reorganizes data dynamically.

Q21. What is Power Query in Excel?
Answer:
Power Query is a tool for importing, cleaning, and transforming data from different sources before analysis.

Q22. What is Remove Blank Rows feature?
Answer:
This feature deletes empty rows in a dataset to make it cleaner.

Q23. What is the use of Find and Replace in Data Management?
Answer:

Find: Locates specific values.
Replace: Finds and substitutes with new values.

Q24. What is the difference between Manual and Automatic Calculation in Excel?
Answer:

Automatic: Excel recalculates formulas whenever data changes.
Manual: Recalculation happens only when user presses F9.

Q25. What is the use of Protect Sheet in Excel?
Answer:
Protect Sheet restricts users from making unwanted changes by locking cells, formulas, or structures.