CCC LibreOffice Calc Online Test 2026 NIELIT CCC 2026 mein LibreOffice Calc chapter se 12–15 questions aate hain — yeh exam ka doosra sabse important chapter hai. Formulas, Functions (SUM/AVERAGE/COUNT), Charts, Cell Referencing, aur AutoFill — in topics pe sabse zyada focus karo.
Chapter 4 — Test Summary
📅 600 Questions ·
📋 30 Tests ·
🎓 Easy · Moderate · Hard ·
🌎 Hindi + English
Is Chapter Mein Kya Aata Hai
SUM / AVERAGE / COUNT
Cell Referencing
Charts & Graphs
AutoFill & AutoSum
Sorting & Filter
Default File Format
Spreadsheet Basics 3
Page Setup And Print 3
Editing And Formatting 3
Rows Columns Management 3
Autofill Sort Filter 4
Formulas And Autosum 4
Functions Sum Count Avg 5
Charts Bar Pie Line 5
Spreadsheet Basics
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Spreadsheet Basics
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Spreadsheet Basics
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Page Setup And Print
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Page Setup And Print
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Page Setup And Print
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Editing And Formatting
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Editing And Formatting
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Editing And Formatting
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Rows Columns Management
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Rows Columns Management
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Rows Columns Management
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Autofill Sort Filter
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Autofill Sort Filter
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Autofill Sort Filter
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Autofill Sort Filter
Test 4 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Formulas And Autosum
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Formulas And Autosum
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Formulas And Autosum
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Formulas And Autosum
Test 4 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Functions Sum Count Avg
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Functions Sum Count Avg
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Functions Sum Count Avg
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Functions Sum Count Avg
Test 4 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Functions Sum Count Avg
Test 5 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Charts Bar Pie Line
Test 1 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Easy
Start Test →
Charts Bar Pie Line
Test 2 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Charts Bar Pie Line
Test 3 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Moderate
Start Test →
Charts Bar Pie Line
Test 4 ✓ FREE
📝 20 Questions
⏱️ 20 minutes
📊 Hard
Start Test →
Charts Bar Pie Line
Test 5 ✓ FREE
📝 19 Questions
⏱️ 19 minutes
📊 Hard
Start Test → Exam Tip
LibreOffice Calc ka default file format .ods hai — MS Excel ka nahi. Formula hamesha = se shuru hoti hai. Absolute reference mein $ sign lagta hai jaise $A$1. COUNT sirf numbers ginata hai, COUNTA text bhi — yahi CCC mein puchha jaata hai.
⚡ Quick Revision — Calc Formulas
=SUM(A1:A10) — Jod=AVERAGE() — Ausat=COUNT() — Sankhya=MAX() — Sabse Bada=MIN() — Sabse Chota=IF() — Condition
Aage Ki Taiyari
❓ Frequently Asked Questions
Q: CCC exam mein LibreOffice Calc se kitne questions aate hain? ▼
A: NIELIT CCC 2026 exam mein LibreOffice Calc Chapter 4 se 12 se 15 questions aate hain. Yah CCC ka doosra sabse important chapter hai. Formulas ka exact syntax, Cell References (Relative vs Absolute), aur Chart types par focus karo.
Q: LibreOffice Calc mein SUM formula kaise likhte hain? ▼
A: LibreOffice Calc mein SUM formula ka syntax yah hai — =SUM(A1:A10). Yah A1 se A10 tak sabhi cells ka total deta hai. Multiple ranges ke liye =SUM(A1:A5,C1:C5) use karo. Yaad raho formula hamesha equal sign se shuru hota hai. CCC Calc test mein formula syntax directly puchha jaata hai.
Q: Absolute aur Relative cell reference mein kya antar hai? ▼
A: Relative reference jaise A1 formula copy karne par automatically change ho jaata hai. Absolute reference jaise dollar A dollar 1 yaani $A$1 copy karne par fix rehta hai kyunki dollar sign row aur column ko lock kar deta hai. Mixed reference mein sirf row ya sirf column lock hota hai jaise A$1 ya $A1. CCC LibreOffice Calc test mein yah antar directly puchha jaata hai.
