✅ Top Excel Interview Questions with Answers: Part-2 🧠

11. How does IF function work?
The IF function checks a condition and returns one value if it's TRUE, another if FALSE.
Syntax: =IF(condition, value_if_true, value_if_false)
Example: =IF(A2>50, "Pass", "Fail")

12. What is the use of COUNTIF and SUMIF?
• COUNTIF counts cells based on a condition.
• SUMIF adds values that meet a condition.
Example:
=COUNTIF(A1:A10, ">50")
=SUMIF(B1:B10, "Apples", C1:C10)

13. What is the difference between CONCATENATE and TEXTJOIN?
• CONCATENATE joins multiple text values (older function).
• TEXTJOIN joins with a delimiter and can ignore empty cells (Excel 2016+).
Example:
=CONCATENATE(A1, " ", B1)
=TEXTJOIN(" ", TRUE, A1:C1)

14. What are Named Ranges and why use them?
A named range is a custom name for a cell or range, useful in formulas.
Example: Name cell A1 as Price, then use =Price*10 instead of =A1*10

15. Explain how to use Filters and Advanced Filters
• Filter: Use the “Filter” button in the Data tab to view specific rows.
• Advanced Filter: Apply criteria from a range to filter complex data.

16. What are Charts in Excel? Types of charts
Charts visualize data.
Types: Column, Bar, Pie, Line, Scatter, Area, Combo, etc.
Use: Select data → Insert → Choose chart type.

17. How do you create a dynamic chart?
Use Excel Tables or named ranges that auto-expand.
Tip: Use OFFSET with defined names to auto-update chart data.

18. What is the use of the MATCH function?
Returns the position of a value in a range.
Syntax: =MATCH(50, A1:A10, 0) → Returns position of 50.

19. Explain the use of the TODAY() and NOW() functions
• TODAY() returns the current date.
• NOW() returns current date and time.
Useful for timestamps or dynamic calculations.

20. How do you use Excel for data cleaning?
• Remove duplicates
• Use TRIM(), CLEAN() to fix formatting
• Use FIND, REPLACE, and Filters
• Use Power Query for more advanced cleanup

Double Tap ♥️ For Part-3