CCC Guru
HomeOnline TestsSyllabusChaptersNotesBlogs
Download App
CCC Guru
HomeOnline TestsCCC SyllabusChaptersStudy NotesBlogs

More

AboutContactPrivacy PolicyTerms of Service
Download App

Android & iOS • Free

CCC Guru

India's trusted platform for NIELIT CCC exam preparation. Free mock tests, notes, and expert resources.

[email protected]

Platform

  • CCC Online Test 2026
  • CCC Full Mock Test
  • NIELIT CCC Syllabus
  • CCC Chapters (Syllabus)
  • CCC Study Notes (PDF)
  • Exam Preparation Blogs

CCC Exam

  • Revised Exam Pattern
  • Practice Tests in Hindi & English
  • Chapter-Wise Mock Tests
  • CCC Study Guides & Tips

Company

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms of Service

© 2026 CCC Guru. All rights reserved. Not affiliated with NIELIT.

Built for NIELIT CCC candidates across India 🇮🇳

HomeChaptersChapter 4: LibreOffice Calc (Spreadsheet)
Chapter 4 of 10 (Official CCC Syllabus)4h Theory + 8h Practical

Chapter 4: LibreOffice Calc (Spreadsheet)

लिब्रेऑफिस कैल्क (स्प्रेडशीट)

Solve practice sets on formulas, functions, charts, and cell formatting. फॉर्मूले, फ़ंक्शन, चार्ट और सेल फॉर्मेटिंग पर आधारित प्रैक्टिस सेट हल करें।

Practice Chapter 4 Online Test (100 Qs)Full Mock TestsFull Syllabus PDF

Key Topics & Learning Objectives

Topics covered under Chapter 4 as per the official NIELIT Revision 4 curriculum:

Topics in English

  • Elements of Electronic Spreadsheet & Interface of LibreOffice Calc
  • Rows, Columns, Cells, Cell Addresses, and Range Selection
  • Entering and Editing Data: Text, Numbers, Dates, and AutoFill Series
  • Inserting and Deleting Rows/Columns, Adjusting Column Width and Row Height
  • Formulas and Mathematical Operators (+, -, *, /, %)
  • Standard Functions: SUM, AVERAGE, COUNT, MAX, MIN, ROUND, IF (Logical Function)
  • Data Sorting, AutoFilter, and Standard Filter
  • Creating and Customizing Charts: Bar Chart, Column Chart, Pie Chart, Line Chart
  • Page Setup, Sheet Protection, and Printing Spreadsheets

मुख्य विषय (हिंदी में)

  • इलेक्ट्रॉनिक स्प्रेडशीट की मूल बातें एवं लिब्रेऑफिस कैल्क (LibreOffice Calc) का इंटरफेस
  • रो (Rows), कॉलम (Columns), सेल (Cells), सेल एड्रेस और रेंज सिलेक्शन
  • डेटा एंट्री एवं एडिटिंग: टेक्स्ट, नंबर्स, डेट और ऑटोफिल (AutoFill) सीरीज
  • रो और कॉलम इन्सर्ट/डिलीट करना, कॉलम की चौड़ाई और रो की ऊंचाई एडजस्ट करना
  • फॉर्मूले और गणितीय ऑपरेटर (+, -, *, /, %)
  • मुख्य फंक्शन्स: SUM, AVERAGE, COUNT, MAX, MIN, ROUND, IF (लॉजिकल फंक्शन)
  • डेटा सॉर्टिंग (Sorting), ऑटोफिल्टर और स्टैंडर्ड फिल्टर
  • चार्ट बनाना एवं कस्टमाइज करना: बार चार्ट, कॉलम चार्ट, पाई चार्ट, लाइन चार्ट
  • पेज सेटअप, शीट प्रोटेक्शन और स्प्रेडशीट प्रिंटिंग
Chapter-Wise Online Assessment

Ready to test your knowledge on LibreOffice Calc (Spreadsheet)?

Attempt objective MCQs in Hindi & English with immediate score evaluation and answers.

Start Chapter 4 Test

Official Syllabus Reference: This chapter guide is aligned with the Course on Computer Concepts (CCC) Revision 4 blueprint published by the National Institute of Electronics and Information Technology (NIELIT), an autonomous scientific society under the Ministry of Electronics and Information Technology (MeitY), Government of India.

Previous ChapterChapter 3: LibreOffice Writer (Word Processing)
Next ChapterChapter 5: LibreOffice Impress (Presentation)
← View All Chapters