Zed-King Institute

    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:00

    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?

    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)

    Q1

    What is the result of =10+5*2 in Calc?

    Answer: 20 — multiplication is done before addition.

    Q2

    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

    Zed-King Study Material · by Zed-King Institute, Kaithal

    Launch offer
    A page from the CCC question bank — questions in English and Hindi with the correct answer markedCover of the Zed-King CCC 2000+ Question Bank PDF

    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 ₹49

    Opens 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.

    Drag me!