Ravindra BagaleCourses & study guides Track your progress
Intermediate level

Intermediate Excel Certificate

By · Last updated:

Beginner Intermediate Advanced

Friends, intermediate test: IF, SUMIFS, XLOOKUP, PivotTables, charts and data validation. Pass at 70%, type your name, get a silver certificate. Name stays on this device only.

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

Why → What → How

Why: Office work needs conditions, lookups and summaries — not only SUM. One Intermediate check shows you are ready for MIS and analyst interviews.

What: Thirty MCQs: IF/IFS, SUMIFS/COUNTIFS, XLOOKUP, PivotTables, charts, data validation and Tables. Pass 70%. Silver certificate with level name, ID and QR.

How:

  1. Read the disclaimer once.
  2. Answer all 30 Intermediate 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

When a story has two conditions, think SUMIFS or Pivot — not a single SUM. When you need a value from another column, think XLOOKUP.

Answered: 0 / 30 · Intermediate

Final test — 30 Intermediate questions

1. IF checks a condition. Correct idea for pass if B2>=35?

2. SUMIF sums with:

3. SUMIFS can use:

4. COUNTIF counts cells that:

5. Best exact-match VLOOKUP fourth argument:

6. XLOOKUP main benefit over classic VLOOKUP?

7. INDEX + MATCH is useful because:

8. A PivotTable is best for:

9. After source data grows, a Pivot often needs:

10. Recommended charts for comparing categories (like regions):

11. Data Validation can:

12. An Excel Table column like Sales[Amount] is a:

13. TEXTJOIN with a comma delimiter helps to:

14. IFS is clearer than deep nested IF when:

15. Priya (Bengaluru MIS) needs total Qty where Region=West AND Status=Open. Best start?

16. Absolute reference $H$1 means:

17. Slicers on a Pivot help you:

18. Omar (Dubai) wants month name from date in A2. Best idea?

19. Remove blank rows before a Pivot mainly to:

20. Conditional Formatting colour scale is good for:

21. Neha (Delhi) builds a Pivot with Region on Rows and Sum of Sales on Values. She is:

22. XLOOKUP default for exact match is typically:

23. Data > Text to Columns helps when:

24. Goal Seek finds:

25. Protect Sheet can stop users from:

26. Emma (NY) uses COUNTIFS for Status=Paid and City=Pune. COUNTIFS needs:

27. Recommended way to make chart titles clear:

28. IFERROR around XLOOKUP is useful to:

29. Sort by two columns (City then Name) uses:

30. A Pivot Calculated Field is for:

Levels: Beginner · Intermediate · Advanced · hub Certificate