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
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
Sample questions from Spreadsheet (LibreOffice Calc)
Q. What is the result of =10+5*2 in Calc?
Answer: 20 — multiplication is done before addition.
Q. 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.
Other CCC Chapter Tests
Chapter 1
Introduction to Computer
25 questions · 20 minOpen TestChapter 2
Operating System
25 questions · 20 minOpen TestChapter 3
Word Processing (LibreOffice Writer)
25 questions · 20 minOpen TestChapter 5
Presentation (LibreOffice Impress)
25 questions · 20 minOpen TestChapter 6
Internet and WWW
25 questions · 20 minOpen TestChapter 7
Email, Social Networking and e-Governance
25 questions · 20 minOpen TestChapter 8
Digital Financial Tools
25 questions · 20 minOpen TestChapter 9
Future Skills and Cyber Security
25 questions · 20 minOpen TestSpreadsheet (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.