CCC Chapter 4 · Free Test
CCC Spreadsheet (LibreOffice Calc) Online Test
Chapter 4: Spreadsheet of the NIELIT CCC syllabus — 25 questions in 20 minutes, in Hindi and English. Every time you start, you get a new set of questions, with the answer and an explanation for each one at the end.
- Free
- No registration
- Result in one click
NIELIT CCC · Chapter 4 Test
25
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?
Question palette · answers are saved as you go
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.
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 nine 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
Chapter 9
Future Skills and Cyber Security
- Internet of Things and Big Data
- Cloud computing — SaaS, PaaS and IaaS
- Artificial Intelligence and Machine Learning
Questions
Spreadsheet (LibreOffice Calc) Test — Questions
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.