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.