Advanced Study Material for Computer Science: LibreOffice Calc Spreadsheet
Review targeted academic resources with the Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc Notes Set 01. Built according to official standards for the 2026-27 term, these downloadable Computer Science study materials support effective daily practice and deeper conceptual understanding for LibreOffice Calc Spreadsheet.
Practice Computer Science Resources: LibreOffice Calc Spreadsheet
Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.
A guide to the basics of LibreOffice Calc in the computer course: what a spreadsheet is, the parts of the Calc window and the menu tabs, creating, opening, saving, printing and closing a workbook, and relative, absolute and mixed cell addressing. It also covers page setup and entering, formatting, selecting, copying, moving and pasting cell data.
Introduction
An electronic spreadsheet is used for analysing, sharing and managing information for accounting purpose, performing mathematical calculations, budgeting, billing, etc. A spreadsheet is a matrix of rows and columns similar to an accounting ledger.
The spreadsheet program also provides tools for creating graphs and inserting pictures, etc., for analysing the data.
Some examples of spreadsheet software are Lotus 1-2-3, Quattro-Pro, Multiplan, MS-Excel, VisiCalc, LibreOffice Calc etc., in which VisiCalc is the oldest spreadsheet software. Here, we will discuss LibreOffice Calc in this chapter.
Elements of Spreadsheet
1. A spreadsheet which is also known as worksheet, is an electronic document in which data is organised in the rows and columns of a grid and can be used in calculations. Each worksheet contains 1048576 rows and 1024 columns.
2. The intersection of each row and column is called cell. It may hold numbers, formulas, text, date and time, etc.
3. A formula is an equation that calculates the value to be displayed. A formula when used in a worksheet, must begin with an equal to (=) sign.
4. A cell pointer is a boundary that specifies which cell is active at particular moment.
5. A cell address is recognised by column letter and row number. e.g. C2 where, C is a column letter and 2 is a row number.
Opening of Spreadsheet (LibreOffice Calc)
You may start LibreOffice Calc by clicking the icon of LibreOffice Calc or from Start button. To open the spreadsheet by Start button as:
Click at Start button → All Programs → LibreOffice 6.2 → LibreOffice Calc.
File extension of LibreOffice Calc is .ods.
By this, the main window of LibreOffice Calc will open on your screen. The window shows the Title Bar, Menu Bar, Standard Toolbar and Formatting Toolbar at the top, the Name Box and Formula Bar below them, the column letters, row numbers, active cell and worksheet in the middle, the Sidebar on the right, and the Sheet Tab and Status Bar at the bottom.
The components of a spreadsheet window are as follows :
Title Bar
The bar located at the top of the window is called title bar. It contains the name of the currently open document.
Formula Bar
It displays the contents of the active cell. This could be a formula, data or just text.
Name Box
It is located on left of the formula bar. It displays the cell reference or the name of the active cell.
Worksheet
LibreOffice Calc consists worksheets. Each worksheet contains columns and rows. Calc documents are stored as files called worksheet.
Workbook
A Calc file is called a workbook. It contains several worksheets. By default, there is one worksheet in a workbook.
Column Letter
Columns run vertically in a worksheet and each one is identified by a letter in the column header.
Row Number
Rows run horizontally in a worksheet and each one is identified by a number in the row header.
Active Cell
The cell with the black outline. Data is always entered into the active cell.
Sheet Tab
The tab at the bottom of a worksheet tells you the name of the worksheet such as Sheet 1, Sheet 2, etc. Switching between worksheets can be done by clicking on the tab of the sheet which you want to access.
Status Bar
It appears at the bottom of the workbook and provides such information like Sum, Average etc.
Menu Bar
When you select an item on the menu bar, a sub menu drop down will appear. Tabs on menu bar are as follows :
File Tab
It is found at the top-left corner of the window. It contains options as New, Open, Open Remote, Templates, Save, Save Remote, Save As, Print Preview, Print etc.
Edit Tab
It contains options as Undo, Redo, Cut, Copy, Paste, Find & Replace etc.
View Tab
It contains options as Normal, Page Break, Formula Bar, Status Bar, Sidebar, Styles, Gallery, Zoom etc.
Insert Tab
It contains options as Image, Media, Chart, Object, Function, Date, Time, Comment, Header and Footer etc.
Format Tab
It contains options as Text, Spacing, Align, Cells, Rows, Page, Conditional, Spreadsheet Theme etc.
Styles Tab
It contains options as Footnote, Update Style, New Style, Manage Styles etc.
Sheet Tab
It contains options as Insert Cells, Insert Rows, Insert Columns, Delete Cells/Rows/Columns, Fill Cells, Rename Sheet, Hide Sheet etc.
Data Tab
It contains options as Sort , Auto Filter, Select Range, Pivot Table, Subtotals, Form, Data Provider etc.
Tools Tab
It contains options as Spelling, Language, AutoCorrect Options, Goal Seek, Forms, Macros, XML Filter Settings etc.
Window Tab
It contains options as New Window, Close Window etc.
Help Tab
It contains options as LibreOffice Help, Send Feedback, Restart in Safe Mode, Donate to LibreOffice, Check for Updates etc.
Toolbar
LibreOffice Calc contains two types of toolbar as formatting toolbar and standard toolbar.
Standard Toolbar
It is located just below the menu bar and contains various options as New, Save, Open, Print etc.
Formatting Toolbar
It is located just below the standard toolbar and contains various options as Font Name, Font Size, Bold, Italic etc.
Sidebar
It is located by default on the right side of the Calc window. But if it is not displaying on the window, you can show this by following :
Click on View tab → select Sidebar option from the drop down that appears. Calc sidebar contains five decks as Properties, Styles, Gallery, Navigator and Functions which show by clicking on its icon.
Creating a New Spreadsheet
Steps to create a new spreadsheet are as follows:
1. Click on File tab.
2. Select New option. A context menu will appear.
3. Select Spreadsheet. A blank spreadsheet will appear on your screen.
Opening an Existing Spreadsheet
Steps to open an existing spreadsheet are as follows :
1. Click on File tab.
2. Select Open or press Ctrl + O shortcut key on keyboard. An Open dialog box will appear.
3. Choose the location and select the file which you want to open.
4. Click Open button.
Addressing of Cells
A cell address or cell reference identifies the location of a cell or group of cells in the worksheet. It consists of the column letter and row number that intersect at the cell's location. e.g. cell address A1, where A is the column letter and 1 is the row number.
We can also refer to a group or range of cells for addressing. Ranges are identified by the cell references of the cells in the upper left and lower right corners of the range.
The two cells references used for a range are separated by a colon (:) which tells Calc to include all the cells between starting and ending points.
For example, A5 : B10
There are three types of addressing as follows :
1. Relative Cell Addressing Relative means that the reference of an area will be adjusted automatically when you copy the formulas.
We can say the cell addressing change when the formula is autofilled into different cell is known as relative cell addressing.
For example, you have entered a formula =A5* B4 in cell C3. Now, if you copy this formula to cell D3, then it will become =B5*C4.
2. Absolute Cell Addressing If you don't want to change the certain part of your cell address when you copy the formula into a new cell, you need to place dollar sign $ before each letter and number in an absolute address. e.g. in $A$5 * B4, $A$5 address will not change when it is copied into another cell.
3. Mixed Cell Addressing It is a combination of absolute and relative cell addressing. e.g. in $A5 * B$4, only relative part will change when it is copied into another cell. e.g. $A5*C$4.
Page Setup
It is used to do page settings like setting margin, page orientation etc. You can change size, layout, orientation and margin of paper through this option.
Steps to do setup of the page are as follows :
1. Select Format tab, a drop down menu will appear.
2. Now, choose Page option from it. Page Style: Default dialog box will appear.
3. Click on Page tab in which three panels are showing as follows :
(a) Paper Format With the help of this panel, user can customize the settings that are related to Size, Height and Width of the paper, Orientation (Portrait or Landscape) etc.
(b) Margins With the help of this panel, user can modify the margin orientation of the page. It allows for the Top, Bottom, Left and Right margins to be set.
(c) Layout Settings With the help of this panel, user can customise the settings that are related to Page layout, Page numbers Table alignment (Horizontal or Vertical).
Printing of Sheet
When you are ready to print your worksheet, you can change the worksheet's properties to ensure that your worksheets display all your information properly.
To print the worksheet, steps are as follows :
1. Click File tab → Print option or press Ctrl+P shortcut key on keyboard.
2. Print dialog box will appear.
3. Select the Printer, enter Number of copies and choose range.
4. Click OK button.
Saving Spreadsheet
Steps to save the spreadsheet are as follows :
1. Click at File tab.
2. Do one of the following:
(a) Choose Save As, if you would like to save the file for the first time or save the file by different name.
(b) Choose Save, if the file has already been named.
(c) Press Ctrl+S on keyboard.
3. Save As dialog box will appear.
4. Type the file name in File name box and choose ODF Spreadsheet from the Save as type list box.
5. Click on Save button. The default extension of LibreOffice Calc is .ods.
Closing Spreadsheet
Steps to close an active spreadsheet are as follows :
1. Click the File tab.
2. Click Close option.
Manipulation of Cells and Sheet
LibreOffice Calc is extremely powerful for entering, storing, displaying and manipulating different kinds of data efficiently. There are three main types of data i.e. text, number and date/time that can be entered and stored in cells.
Entering Text, Number and Date
Entering the Text in a Cell
Steps to enter a text in a cell are as follows:
1. Select the cell in which you want to enter text.
2. Start typing the text.
3. Press the Enter key.
Modifying the Text in a Cell
Text can be modified in a cell. You can set the alignment, font, size and color, etc., from formatting toolbar.
Entering the Number in a Cell
Steps to enter the number in a cell are as follows :
1. Select the cell, where you want to enter a number.
2. Type the number. You can use %, (,), ., $, E, etc., in the number.
3. Press the Enter key.
Modifying the Number in a Cell
You can set the number format in a cell. Steps to set the format of number cell are as follows:
1. Select the cell, which you want to format.
2. Click Format tab → Number Format A. context menu will appear. The menu lists the formats General (Ctrl+Shift+6), Number (Ctrl+Shift+1), Percent (Ctrl+Shift+5), Currency (Ctrl+Shift+4), Date (Ctrl+Shift+3), Time, Scientific (Ctrl+Shift+2) and Thousands Separator.
3. Select the desired format from the list. By default, the cell format is General.
Entering the Date/Time in a Cell
Steps to enter the date/time in a cell are as follows :
1. Select the cell, where you want to type a date/time.
2. Type date/time.
3. When you type a date/time, Calc converts, your date to a serial number. The serial number represents the number of days from the beginning of the century until the date you type.
Modifying the Date /Time in a Cell
Steps to set the format of Date /Time are as follows :
1. Select the cell, which you want to format.
2. Click Date or Time format respectively from the Number Format list.
3. After a cell has been formatted in date or time format, Date/Time will be in general form dd/mm/yy, HH : MM : SS format.
Shortcut Keys to Enter Current Date/Time
To insert the current date, press Ctrl+ ;
To insert the current time, press Ctrl + Shift+ ;
To insert the current date and time, press Ctrl + ; then press SPACE and then press Ctrl + Shift + ;
Editing Cell Content
We can edit worksheet data by performing several operations. Some common operations are as follows :
Selecting Cells
You may want to select multiple cells or range in a worksheet in order to enter data in those cells or to format all of the selected cells at one time. Several methods to select multiple cells in a worksheet are as follows :
1. To select a single entire column, click a column heading, i.e. the letter or letters that indicate the column.
2. To select multiple columns, drag across multiple column headings.
3. To select a single entire row, click the row number.
4. To select multiple rows, drag across multiple row numbers.
5. To select sequential cells, click the first cell, hold down the Shift key and click the last cell you want. Optionally, click and drag the mouse over a group of cells to select a sequential area.
6. To select non-sequential cells, click the first cell, hold down the Ctrl key, and click each additional cell (or row or column) you want to select.
7. To select the entire worksheet, click the small box located to the left of column A and above row 1. You can select all cells in a worksheet by pressing Ctrl + A.
Different types of shapes are available to select the cells are as follows :
| Pointer Shape | Use |
|---|---|
| Up arrow | To select cells, row number, column letter |
| Left-right double arrow | To change column width |
| Up-down double arrow | To change row height |
| Plus sign (+) | To AutoFill in cells |
Formatting Cells
When we format cells in Calc, we can change the appearance of a number without changing the number itself. Steps to format the cells are as follows :
1. Enter the value into a cell.
2. Select the cell and right click, then click Format Cells. Format Cells dialog box will appear.
3. Format Cells dialog box provides many tabs to format the cells. Tabs and their groups on the Format Cells dialog box are as follows :
| Tabs | Groups |
|---|---|
| Numbers | Category, Format, Language, Options, Format code |
| Font | Font, Style, Size, Language |
| Font Effects | Font color, Overlining, Strikethrough, Underlining |
| Alignment | Text Alignment, Text Orientation, Properties |
| Borders | Line Arrangement, Line, Padding, Shadow Style |
| Background | None, Color |
| Cell Protection | Protection, Print |
Cut, Copy and Paste
These options work same as they do in Writer, which we have studied earlier. But, we will look at these options in terms of cells.
Selecting a Range of Cells
A range of cells may contain a single cell or a group of cells. Basically, it is a group of contiguous cells forming a rectangular area of cells. When we select a cell, its name gets displayed in the Name Box.
Similarly, the name of the selected range of cells also gets displayed in the same Name Box. e.g. a range starting from E3 till G15 would be written as E3:G15. Here, colon (:) represents the range indicator. We can do this in two ways, through keyboard or mouse.
I. Using Keyboard
For selecting a range of cells using keyboard, do the following :
1. Point to the first cell that you want to be included in the range of cells.
2. Then, press and hold the Shift key and move to the diagonally opposite cell using arrow keys to the cells that you want to be included in the range of cells.
3. Lastly, release the Shift key.
II. Using Mouse
For selecting a range of cells using mouse, do the following :
1. Point to the first cell that you want to be included in the range of cells.
2. Now, press the left mouse button and drag it to the diagonally opposite last cell of the range that you want to select.
3. Release the mouse button.
Note If you want to select the cell of first row and first column to the cell of fourth row and sixth column, then name of this range would be A1:F4. The range will be displayed in the Name Box.
Copying a Range
For copying a range in Calc, we can use simple Copy and Paste option from standard toolbar. For copying a cell range, do the following:
1. First select the range of the cell that you want to copy at other place in Calc using any of the below given methods.
2. Then, click on the Copy button from standard toolbar. Alternatively, you can click on right mouse button and select Copy option from there or you can simply press Ctrl+ C through your keyboard.
3. Now, you need to select the cell where you want to copy the selected range data.
4. Click on Paste button from standard toolbar. Alternatively, you can click on right mouse button and select Paste option from there or you can simply press Ctrl + V through your keyboard then, the desired data will be copied.
Moving a Range
Moving means original data will be shifted to a new location, i.e. original data will be cut and pasted to the desired location. For moving a range, you need to perform the similar steps as for copying range.
But, in place of Copy button, for moving, you need to click on the Cut button. Rest everything is same.
However, there is one more yet easiest method for doing the same task using mouse.
For moving a range to the desired location, do the following :
1. Select the range of cells that you want to move to other location.
2. Then, move the mouse pointer at the boundary of the selected cell range. Mouse pointer will convert to a hand shape.
3. Click there and move the range to the target location.
Paste Special
This option is used when you want to paste particular items as only numbers, only formulae , only text etc. Paste special is helpful when you paste one type of data out of different type of data.
Steps to paste special are as follows:
1. Click on Edit tab → Paste Special. A context menu will appear. The menu lists Paste Unformatted Text (Ctrl+Alt+Shift+V), Paste Only Text, Paste Only Numbers, Paste Only Formula and Paste Special... (Ctrl+Shift+V).
2. Select the option as per your need.
Changing Cell Height and Width
On a worksheet, you can specify a column width of 0 to 255. This value represents the number of characters.
The default column width is 8.43 characters. You can specify a row height of 0 to 409. This value represents the height measurement in points and the default row height is 15 points.
Free study material for Computer Science
CBSE Computer Science Study Material: LibreOffice Calc Spreadsheet
Comprehensive Study Resources for LibreOffice Calc Spreadsheet
Review targeted study resources for LibreOffice Calc Spreadsheet tailored for learners. Utilizing these structured notes and quick-revision tools ensures complete alignment with current CBSE evaluation standards.
Understanding Marking Schemes
Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within LibreOffice Calc Spreadsheet and demystifies standard marking schemes for Computer Science evaluations.
Complete Revision for Computer Science
Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.