21. What is Countif function and how to use it?
Countif counts the number of cells meeting a criterion. Example:
=COUNTIF(A2:A10, ">50") counts cells with values > 50.22. What is Nested IF function?
A Nested IF uses multiple IFs to evaluate several conditions sequentially. Example:
=IF(A1>90,"A",IF(A1>80,"B","C"))23. What is Pivot table and why do we use it?
Pivot Table summarizes large data quickly by grouping, counting, and calculating aggregates to analyze data interactively.
24. How to use advanced filter?
Advanced filter extracts unique or specific data by setting complex criteria and copying filtered results to a new location.
25. How can we change the cell formatting?
Use Format Cells (Ctrl+1), then select Number, Font, Border, or Fill options to adjust appearance and data format.
26. What is conditional formatting and how to use it?
Allows cells to be formatted (color, font) automatically based on rules, e.g., highlight scores above 80 in green.
27. How to make drop down list?
Use Data Validation > List, then select the source range to create a dropdown in a cell.
28. How to make dynamic drop down list?
Create dynamic named ranges using OFFSET and COUNTA, then use them as the source in Data Validation list.
29. How can we determine the day of the week for a particular date?
Use the formula
=TEXT(date, "dddd") or =WEEKDAY(date) for numeric day value.30. What is chart and how can we use it?
Charts graphically represent data trends and comparisons. Create charts by selecting data and choosing chart type from Insert tab.
React ♥️ if this helped you