Ravindra BagaleCourses & study guides Track your progress
Advanced level

Advanced Excel Certificate

By · Last updated:

Beginner Intermediate Advanced

Friends, advanced test: FILTER/UNIQUE, LET/LAMBDA, Power Query, Power Pivot/DAX basics, Goal Seek/Scenario and macros. Pass at 70% for a gold certificate. Nothing uploaded.

Important: This is a self-assessment certificate of completion for Ravindra Bagale’s free Excel study materials (Advanced level). It is not an accredited university, government, or board qualification. Nobody proctors the test.

Why → What → How

Why: Senior Excel work means clean data pipelines, dynamic arrays and light models — not only VLOOKUP. This Advanced check proves that depth.

What: Thirty MCQs: dynamic arrays, LET/LAMBDA, Power Query, Power Pivot/DAX basics, what-if tools and macros. Pass 70%. Gold certificate with level, ID and QR.

How:

  1. Read the disclaimer once.
  2. Answer all 30 Advanced questions.
  3. Click Check score (pass mark 70%).
  4. Type your full name (stays on this device only).
  5. Click Make my certificate, then Print or Download PNG.
  6. Or pick another level above if this one is too easy or too hard.

Ravindra Bagale’s Tip

Power Query cleans before the sheet. Dynamic arrays spill. DAX measures belong in the model. Macros automate clicks — pick the right tool for the story.

Answered: 0 / 30 · Advanced

Final test — 30 Advanced questions

1. FILTER function mainly:

2. UNIQUE(A2:A100) returns:

3. SORT and SORTBY are:

4. LET stores:

5. LAMBDA lets you:

6. Power Query (Get & Transform) is best for:

7. In Power Query, Append roughly means:

8. In Power Query, Merge roughly means:

9. Unpivot in Power Query turns:

10. Power Pivot data model is for:

11. A basic DAX SUM measure idea looks like:

12. CALCULATE in DAX is mainly used to:

13. RELATED in DAX (simplified idea) pulls:

14. XLOOKUP with dynamic arrays can return:

15. SEQUENCE(5) returns:

16. Goal Seek finds an input for a target. Scenario Manager stores:

17. Data Table (What-If) is useful for:

18. Recording a macro mainly:

19. Personal Macro Workbook is for:

20. DYNAMIC arrays #SPILL! usually means:

21. Priya (Hyderabad analytics) loads 24 monthly CSVs. Best first tool?

22. Omar (Dubai FP&A) wants a measure that ignores a slicer on Region. He studies:

23. LET(x, A1*B1, x+10) uses x as:

24. MAP / SCAN (Microsoft 365 lambda helpers) work on:

25. Power Query query folding (idea) means:

26. A star schema in the model usually has:

27. Emma (NY) needs distinct customer count in DAX. Common pattern:

28. TOCOL / TOROW help you:

29. Application.ScreenUpdating = False in VBA often:

30. Neha (Pune) builds a what-if model with three interest rates saved as scenarios. Tool?

Levels: Beginner · Intermediate · Advanced · hub Certificate