Beginner Excel Certificate
Friends, this is the Beginner final test. Basics, formatting, SUM and AVERAGE, sort and filter. Score 70% or more, type your name, print or download your bronze certificate. Nothing is uploaded.
चला मित्रांनो — ही Beginner अंतिम चाचणी आहे. Basics, formatting, SUM/AVERAGE, sort आणि filter. 70%+ गुण, नाव टाइप करा, bronze प्रमाणपत्र print/download करा. काहीही upload होत नाही.
चलो दोस्तों — यह Beginner फाइनल टेस्ट है. Basics, formatting, SUM/AVERAGE, sort और filter. 70%+ स्कोर, नाम लिखो, bronze सर्टिफिकेट print/download करो. कुछ अपलोड नहीं होता.
Why → What → How
Why: Many friends finish early Excel chapters but never check basics in one sitting. A short Beginner test builds confidence for office and interviews.
What: Thirty easy MCQs: cells, workbooks, formatting, SUM, AVERAGE, COUNT, sort, filter, and small industry stories. Pass mark 70% (21/30). Bronze certificate with your name, date, ID and QR to the Excel hub.
How:
- Read the disclaimer once.
- Answer all 30 Beginner questions.
- Click Check score (pass mark 70%).
- Type your full name (stays on this device only).
- Click Make my certificate, then Print or Download PNG.
- Or pick another level above if this one is too easy or too hard.
Ravindra Bagale’s Tip
Read each question once. Look for the simple Excel word: SUM adds, AVERAGE means, Filter hides rows — do not overthink.
Ravindra Bagale’s Tip – मराठी
प्रत्येक प्रश्न एकदा वाचा. साधे Excel शब्द शोधा: SUM बेरीज, AVERAGE सरासरी, Filter ओळी लपवतो.
Ravindra Bagale’s Tip – हिंदी
हर सवाल एक बार पढ़ो. सादे Excel शब्द ढूँढो: SUM जोड़ता है, AVERAGE औसत, Filter पंक्तियाँ छुपाता है.
Final test — 30 Beginner questions
1. Priya (Mumbai retail) wants the total of daily sales in B2:B10. Best formula?
2. Amit (Pune bank) needs the average balance in C2:C20. Correct formula?
3. A cell address like D5 means:
4. A workbook is:
5. A worksheet is:
6. COUNT counts which cells?
7. COUNTA counts which cells?
8. Sara (London HR) wants the highest score in E2:E30. Formula?
9. MIN finds:
10. To make text bold quickly you often use:
11. Number format for Indian rupee style amounts is mainly:
12. Omar (Dubai sales) enters 0.15 and wants it to show as 15%. He should use:
13. Merge & Center is used to:
14. Wrap Text helps when:
15. Neha (Delhi store) wants to sort a name list A to Z. She should use:
16. Filter (Data > Filter) is best to:
17. Freeze Panes is used to:
18. Ctrl+C then Ctrl+V means:
19. Flash Fill helps when Excel sees a pattern (like split first name) and:
20. Remove Duplicates keeps:
21. Emma (NY clinic) types 12 in a cell formatted as text. SUM may:
22. Fill Handle (small square at cell corner) is used to:
23. Which shortcut opens the Format Cells dialog on Windows?
24. Ravi (Chennai logistics) wants row height taller for wrapped notes. He changes:
25. To clear only formats but keep values, use:
26. AutoSum commonly inserts:
27. LEFT("Mumbai",3) returns:
28. TODAY() returns:
29. Conditional Formatting can:
30. A basic Excel Table is often created with:
Well done. Type the name for your Beginner certificate. Spelling matters. Name stays in this browser only.
Please type your name (at least 2 letters).
You need 21 / 30 (70%) for the Beginner certificate. Revise, clear answers, try again.
Your Beginner certificate
Print (certificate-focused print CSS) or download PNG. ID prefix RB-EXL-B- + hash of name+date.
Levels: Beginner · Intermediate · Advanced · hub Certificate