Sub Hello()
MsgBox "Welcome"
End Sub
56. How Do You Clean Data in Excel?
Answer:
Common techniques:
✔ Remove duplicates
✔ TRIM spaces
✔ Replace missing values
✔ Fix date formats
✔ Standardize text
Functions used:
TRIM()CLEAN()PROPER()UPPER()LOWER() 57. How Do You Remove Duplicates?
Answer:
Steps:
1. Select data
2. Data Tab
3. Remove Duplicates
Or use:
=UNIQUE(A:A)
(Excel 365)
58. What is Flash Fill?
Answer:
Flash Fill automatically detects patterns and fills data.
Example:
Input: John Smith
Desired output: J.Smith
Excel automatically learns the pattern.
Shortcut: Ctrl + E
59. What are Named Ranges?
Answer:
Named Ranges assign names to cells or ranges.
Example:
Instead of:
=A1:A100Use:
SalesData Benefits:
✔ Better readability
✔ Easier formulas
60. Explain Text Functions in Excel.
Common functions:
LEFT()RIGHT()MID()LEN()TRIM()CONCAT()TEXT() Example:
=LEFT(A1,3)
Returns first 3 characters.
61. What are Charts in Excel?
Answer:
Charts visually represent data.
Common charts:
✔ Bar Chart
✔ Line Chart
✔ Pie Chart
✔ Scatter Plot
✔ Histogram
62. How Do You Create Dynamic Dashboards?
Answer:
Use:
✔ Pivot Tables
✔ Pivot Charts
✔ Slicers
✔ Dynamic Named Ranges
✔ Power Query
This allows dashboards to update automatically.
63. What is Goal Seek?
Answer:
Goal Seek finds the required input value to achieve a desired result.
Example:
"What sales amount is needed to achieve ₹1,00,000 profit?"
64. What is Solver?
Answer:
Solver is an optimization tool.
Used to:
✔ Maximize profit
✔ Minimize cost
✔ Optimize resource allocation
Examples:
Budget planning
Production planning
65. Explain What-If Analysis.
Answer:
What-If Analysis evaluates different scenarios.
Tools include:
✔ Goal Seek
✔ Scenario Manager
✔ Data Tables
Example:
"What happens if sales increase by 20%?"
🔥 Most Important Excel Topics for Data Analyst Interviews
Recruiters frequently ask about:
✅ VLOOKUP / XLOOKUP
✅ INDEX + MATCH
✅ Pivot Tables
✅ Conditional Formatting
✅ Power Query
✅ IFERROR
✅ SUMIF / SUMIFS
✅ Dashboards
✅ Data Cleaning
✅ Excel Shortcuts
💡 Interview Tip:
If you're interviewing for a Data Analyst role, be ready to explain how you've used Excel to clean data, build reports, create dashboards, and automate repetitive tasks. Real-world examples make your answers much stronger than simply defining concepts.
Double Tap ❤️ For Part-3 🚀