๐ 1. What are the key features of Excel?
Answer: Excel provides functionalities like formulas, functions, pivot tables, charts, conditional formatting, and data filtering to analyze and visualize data efficiently.
๐ 2. How do you use VLOOKUP and what are its limitations?
Answer: VLOOKUP searches for a value in the first column of a range and returns a value in the same row from a specified column. Limitations include searching only from left to right and it stops at the first match.
๐ 3. What is a Pivot Table and why is it used?
Answer: A Pivot Table summarizes large datasets dynamically, allowing quick grouping, sorting, and aggregations like sums or averages.
๐ 4. How can you handle missing or incorrect data in Excel?
Answer: Use filters to identify blanks, functions like IFERROR, ISNA, and tools like Data Validation or Conditional Formatting to highlight or correct data.
๐ 5. Explain how to use IF statements in Excel.
Answer: IF checks a condition and returns one value if TRUE and another if FALSE, e.g.,
=IF(A1>50, "Pass", "Fail").๐ 6. What are absolute and relative cell references?
Answer: Relative references change when copied (like
A1), whereas absolute references stay fixed using $ signs (like $A$1).๐ 7. Describe how to create charts in Excel.
Answer: Select data range and pick chart type; customize axes, legends, and styles to visualize data insights.
๐ 8. What is conditional formatting?
Answer: Tool to apply formatting to cells automatically based on rules (e.g., highlight all values above 100).
๐ 9. How do you perform data validation in Excel?
Answer: Set rules on cells to restrict input types or ranges, ensuring data quality.
๐ ๐ Describe the use of INDEX and MATCH functions together.
Answer: Combined to perform flexible lookups allowing searches in any column or row, overcoming VLOOKUP limitations.
๐ก Pro Tip: Practice common Excel formulas and visualize datasets to discuss your answers confidently. Share examples from your own work to stand out.
โค๏ธ Tap for more!