Mid Advanced Level (20 Questions)

Q1. What is Power Query?
👉 Tool for data cleaning & transformation

Q2. Use of Power Query?
👉 Import, clean, merge data

Q3. What is Power Pivot?
👉 Data modeling tool

Q4. What is DAX?
👉 Formula language for Power Pivot

Q5. What is calculated column?
👉 New column using formula

Q6. What is measure in DAX?
👉 Aggregated calculation

Q7. What is slicer?
👉 Interactive filter

Q8. What is timeline?
👉 Date filter

Q9. What is pivot chart?
👉 Chart from pivot

Q10. What is data model?
👉 Relationship between tables

Q11. What is relationship in Excel?
👉 Link between tables

Q12. What is GETPIVOTDATA?
👉 Extract pivot data

Q13. What is dynamic named range?
👉 Auto-updating range

Q14. What is OFFSET function?
👉 Dynamic reference

Q15. What is INDIRECT?
👉 Reference by text

Q16. What is array formula?
👉 Multi-value calculation

Q17. What is spill range?
👉 Dynamic array output

Q18. What is FILTER function?
👉 Extract specific data

Q19. What is UNIQUE function?
👉 Remove duplicates

Q20. What is SORT function?
👉 Dynamic sorting