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
Test 1 ✓ FREE
Spreadsheet Basics
Test 2 ✓ FREE
Spreadsheet Basics
Test 3 ✓ FREE
Page Setup And Print
Test 1 ✓ FREE
Page Setup And Print
Test 2 ✓ FREE
Page Setup And Print
Test 3 🔒 PREMIUM
Editing And Formatting
Test 1 ✓ FREE
Editing And Formatting
Test 2 ✓ FREE
Editing And Formatting
Test 3 ✓ FREE
Rows Columns Management
Test 1 ✓ FREE
Rows Columns Management
Test 2 🔒 PREMIUM
Rows Columns Management
Test 3 ✓ FREE
Autofill Sort Filter
Test 1 ✓ FREE
Autofill Sort Filter
Test 2 ✓ FREE
Autofill Sort Filter
Test 3 ✓ FREE
Autofill Sort Filter
Test 4 ✓ FREE
Formulas And Autosum
Test 1 ✓ FREE
Formulas And Autosum
Test 2 ✓ FREE
Formulas And Autosum
Test 3 ✓ FREE
Formulas And Autosum
Test 4 ✓ FREE
Functions Sum Count Avg
Test 1 ✓ FREE
Functions Sum Count Avg
Test 2 ✓ FREE
Functions Sum Count Avg
Test 3 ✓ FREE
Functions Sum Count Avg
Test 4 ✓ FREE
Functions Sum Count Avg
Test 5 🔒 PREMIUM
Charts Bar Pie Line
Test 1 ✓ FREE
Charts Bar Pie Line
Test 2 ✓ FREE
Charts Bar Pie Line
Test 3 ✓ FREE
Charts Bar Pie Line
Test 4 🔒 PREMIUM
Charts Bar Pie Line
Test 5 🔒 PREMIUM
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