Excel Course Certificate
Friends, take a 30-question final test from our Excel course. Score 70% or more, type your name, and print or download a certificate. Your name stays on this device only. Nothing is uploaded.
चला मित्रांनो — आमच्या Excel कोर्समधून 30 प्रश्नांची अंतिम चाचणी द्या. 70% किंवा जास्त गुण मिळाल्यास नाव टाइप करा आणि प्रमाणपत्र print / download करा. नाव फक्त तुमच्या डिव्हाइसवर राहते. काहीही upload होत नाही.
चलो दोस्तों — हमारे Excel कोर्स से 30 सवालों की फाइनल टेस्ट दो. 70% या अधिक स्कोर पर अपना नाम लिखो और सर्टिफिकेट print / download करो. नाम सिर्फ आपके डिवाइस पर रहता है. कुछ अपलोड नहीं होता.
Why → What → How
Why: Friends finish many chapters but have no simple proof they sat a full mixed test. A short final check builds confidence for interviews and office work.
What: Thirty multiple-choice questions from the Excel course (formulas, lookups, PivotTables, cleaning, tables, dates, and small industry stories). Pass mark is 70% (21 out of 30). Then you get a printable certificate with your name, date, certificate ID, signature line, and a QR back to the Excel hub.
How:
- Read the disclaimer above once.
- Answer all 30 questions (one choice each).
- Click Check score.
- If you scored 70% or more, type your full name.
- Click Make my certificate, then Print or Download PNG.
- If below 70%, revise the weak topics and try again.
Ravindra Bagale’s Tip
Do not guess every answer in a rush. Read each industry line once — the story is short, but it tells you which tool fits (SUMIF vs Pivot vs XLOOKUP).
Ravindra Bagale’s Tip – मराठी
घाईने सगळे guess करू नका. प्रत्येक industry ओळ एकदा वाचा — छोटी गोष्ट सांगते कोणते tool बसते (SUMIF vs Pivot vs XLOOKUP).
Ravindra Bagale’s Tip – हिंदी
जल्दबाज़ी में सब guess मत करो. हर industry लाइन एक बार पढ़ो — छोटी कहानी बताती है कौन सा टूल सही है (SUMIF vs Pivot vs XLOOKUP).
Choose your level
Take a 30-question test at your level. Pass at 70% for a printable self-assessment certificate (bronze / silver / gold).
Basics, formatting, SUM/AVERAGE, sort & filter Intermediate Silver
IF, SUMIFS, XLOOKUP, pivots, charts, validation Advanced Gold
Dynamic arrays, LET/LAMBDA, Power Query, DAX, macros
Or stay on this page for the mixed general final test below.
Final test — 30 questions
1. Priya (Mumbai retail) wants the total of B2:B20. Best formula?
2. Amit (Pune bank) needs average balance in C2:C50. Which is correct?
3. COUNT counts which cells?
4. COUNTA counts which cells?
5. Sara (London HR) marks Pass if score >= 35 in B2. Formula?
6. To keep H1 fixed when copying a formula, write:
7. Best exact-match VLOOKUP fourth argument:
8. XLOOKUP main benefit over classic VLOOKUP?
9. Ctrl+T (or Insert > Table) creates a:
10. TRIM mainly removes:
11. TODAY() returns:
12. Ravi (Chennai logistics) sums Qty where Region is West. Best start?
13. SUMIFS can use:
14. A PivotTable is best for:
15. Numbers that will not SUM are often:
16. Neha (Delhi manufacturing) sees #DIV/0!. Cause?
17. #N/A in a lookup usually means:
18. LEFT("Mumbai",3) returns:
19. TEXTJOIN(", ",TRUE,A1:A3) is useful to:
20. Flash Fill helps when:
21. Data Validation can:
22. Freeze Panes is used to:
23. Remove Duplicates tool:
24. Conditional Formatting can:
25. Goal Seek is for:
26. Omar (Dubai sales) wants month name from a date in A2. Good formula?
27. INDEX + MATCH is useful because:
28. An Excel Table column reference like Sales[Amount] is called:
29. Power Query (Get & Transform) is best for:
30. Emma (NY healthcare) needs % of target: Actual in B2, Target in C2. Formula?
Well done. Type the name you want on the certificate. Spelling matters — check once. Your name is used only in this browser to draw the certificate. We do not save or send it.
Please type your name (at least 2 letters).
You need 21 / 30 (70%) to unlock the certificate. Open the chapters you missed, practise a few tasks, then clear answers and try again. No rush.
Your certificate
Print this page (certificate only in print view) or download a PNG. Certificate ID is a short hash of your name + date — same inputs give the same ID on this device.
Related: Interview Prep · Functions · Formula practice.