CCC Chapter 4 · Free Test
CCC Chapter 4 Online Test — Spreadsheet (LibreOffice Calc)
Chapter 4: Spreadsheet of the NIELIT CCC syllabus — 25 questions in 20 minutes, in Hindi and English, with the answer and an explanation for each one at the end.
- Free forever
- No registration
- Result in one click
Next NIELIT CCC exam: 17–19 December 2026Updated November 2026
NIELIT CCC · Chapter 4 Test
20:0025
Questions
20
Minutes
25
Marks
50%
To pass
In this test
- Rows, columns, cells and cell addresses (.ods)
- Formulas and operator order
- SUM, AVERAGE, MAX, MIN, COUNT, COUNTA and IF
- Relative, absolute and mixed references
- Errors — ###, #DIV/0!, #NAME?
Free CCC Sunday Mock — 100 questions, live rank list
Sun, 22 Nov · 11 AM — everyone starts together · Hindi + English · register now in the free app
Hindi + English
Every question in both languages, as in the real exam.
New paper every time
Questions are drawn again each time you press Start.
No negative marking
Attempt every question — a wrong answer costs nothing.
Instant result
Score, NIELIT grade and an explanation for each answer.
Quick answer
The CCC Chapter 4 online test covers Spreadsheet (LibreOffice Calc) (Chapter 4: Spreadsheet): Rows, columns, cells and cell addresses (.ods); Formulas and operator order; SUM, AVERAGE, MAX, MIN, COUNT, COUNTA and IF, and more. It has 25 questions in 20 minutes, in Hindi and English, with no negative marking. It is free — enter your name, press Start and a new set of questions is drawn each time. For the full exam, take the 100-question CCC mock test.
Chapter 4
What this chapter test covers
The spreadsheet chapter is asked on LibreOffice Calc. Expect questions on cells and ranges, formulas and functions, cell references, error values, charts, sorting and filtering — and small calculations you must work out yourself.
- Rows, columns, cells and cell addresses (.ods)
- Formulas and operator order
- SUM, AVERAGE, MAX, MIN, COUNT, COUNTA and IF
- Relative, absolute and mixed references
- Errors — ###, #DIV/0!, #NAME?
- Charts, sorting and AutoFilter
- Freeze rows and columns, merge cells
Try these first
Sample questions from Spreadsheet (LibreOffice Calc)
What is the result of =10+5*2 in Calc?
Answer: 20 — multiplication is done before addition.
What is the default extension of a Calc file?
Answer: .ods (OpenDocument Spreadsheet).
Finished this chapter? Take the full CCC mock test with 100 questions from all ten chapters, or revise first with the free CCC chapterwise notes.
Keep practising
Other CCC Chapter Tests
Chapter 1
Introduction to Computer
- CPU, ALU, Control Unit and memory
- RAM, ROM, cache and secondary storage
- Bit, byte, KB, MB, GB and TB
Chapter 2
Operating System
- Functions and types of operating system
- Linux, Ubuntu, kernel and shell
- Booting — cold boot and warm boot
Chapter 3
Word Processing (LibreOffice Writer)
- Creating, saving and printing a document (.odt)
- Bold, italic, underline, superscript and subscript
- Paragraph alignment and line spacing
Chapter 5
Presentation (LibreOffice Impress)
- Slides, layouts and placeholders (.odp)
- Normal, Outline, Notes and Slide Sorter views
- Master slide and templates
Chapter 6
Internet and WWW
- History — ARPANET and the World Wide Web
- LAN, MAN and WAN
- IP address, DNS and URL
Chapter 7
Email, Social Networking and e-Governance
- Email address, To, CC and BCC
- Inbox, Drafts, Spam and attachments
- SMTP, POP3 and IMAP
Chapter 8
Digital Financial Tools
- UPI, BHIM and Virtual Payment Address
- NEFT, RTGS and IMPS
- IFSC and MICR codes
Zed-King Study Material · by Zed-King Institute, Kaithal
Launch offer

PDF · 198 pages
CCC Question Bank — 2000+ Questions
पूरा CCC सिलेबस — 2,002 सवाल answer के साथ, Hindi + English में
The free tests give you a new paper every time. To revise every question in one place before the exam, get the complete question bank.
फ्री टेस्ट हर बार नया पेपर देते हैं। Exam से पहले सारे सवाल एक जगह दोहराने के लिए पूरा question bank लें।
- 2,002 questions with answers — 1,320 MCQs + 682 True/False
- Every question in Hindi + English
- 20 practice sets, full NIELIT CCC syllabus
- Abbreviations, important terms and LibreOffice shortcut keys
₹49Launch offer price
Get the PDF for ₹49Opens in the Zed-King Study app · pay by UPI · read it inside the app · See what is inside
Questions
Spreadsheet (LibreOffice Calc) Test — Questions
Which chapter of the CCC syllabus is Spreadsheet (LibreOffice Calc)?
Spreadsheet (LibreOffice Calc) is Chapter 4 of the ten chapters in the NIELIT CCC syllabus (Revision 4) ("Chapter 4: Spreadsheet"). This page has a free online test for that chapter only.
How many questions are in the CCC Spreadsheet (LibreOffice Calc) test?
Each test has 25 questions from Chapter 4: Spreadsheet, to be finished in 20 minutes. There is no negative marking.
Is the LibreOffice Calc test in Hindi or English?
Both. Every question is shown in Hindi and English together, as in the NIELIT CCC exam.
Do I get the same questions if I take the test again?
No. A new paper is drawn from the chapter's question bank every time you start, so you can practise the chapter again and again.
Ready for the Spreadsheet (LibreOffice Calc) test?
25 questions · 20 minutes · Hindi and English · free, with no registration.
