Pro Advanced Level (20 Questions)

Q1. What are Macros?
👉 Record and automate tasks

Q2. What is VBA?
👉 Programming language in Excel

Q3. Difference between Macro & VBA?
👉 Macro = recorded
👉 VBA = coded

Q4. What is a module in VBA?
👉 Code container

Q5. What is a loop in VBA?
👉 Repeat action

Q6. What is IF in VBA?
👉 Conditional logic

Q7. What is user form?
👉 Input form

Q8. What is event in VBA?
👉 Trigger action

Q9. What is workbook event?
👉 Trigger in file

Q10. What is worksheet event?
👉 Trigger in sheet

Q11. What is automation in Excel?
👉 Task auto-run

Q12. What is dashboard?
👉 Interactive report

Q13. KPI dashboard?
👉 Track performance

Q14. What is data visualization?
👉 Charts/graphs

Q15. What is scenario manager?
👉 Compare scenarios

Q16. What is goal seek?
👉 Find required value

Q17. What is solver?
👉 Optimization tool

Q18. What is data consolidation?
👉 Combine multiple data

Q19. What is Excel integration?
👉 Connect with tools (like Power BI)

Q20. What is real-time dashboard?
👉 Auto-updating dashboard