Official Study Materials for Computer Science
Access comprehensive study materials and useful resources for LibreOffice Calc Spreadsheet using the Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc Notes Set 02. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.
Advanced Resources for Computer Science
Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.
Notes on working with data in LibreOffice Calc: setting column width and row height, inserting and deleting cells, rows and columns, AutoFill, sorting, filtering and freezing panes. Also covers formulas and operators, function categories, SUM, AVERAGE, COUNT, MAX and MIN, chart types and creation, AutoSum and a table of Calc shortcut keys.
Manipulation of Cells and Sheet (continued)
To Set a Column to a Specific Width
Steps to set a column to specific width, do the following :
1. Select the column or columns that you want to change.
2. On the Format tab, click Columns option.
3. A Context menu will appear click Width.
4. Column Width dialog box will appear.
5. In the Width field, type the value that you want.
6. Click OK button.
Tip To quickly set the width of a column, right-click the selected column letter, click Column Width and then type the value that you want.
To Set a Row to a Specific Height
To set a row to specific height, do the following steps :
1. Select the row or rows that you want to change.
2. On the Format tab, click Rows option.
3. Row Height dialog box will appear.
4. In the Height field, type the value that you want.
5. Click OK button.
Tip To quickly set the height of a row, right-click the selected row number, click Row Height and then type the value that you want.
Inserting/Deleting Cells, Rows and Columns
As we already know that an Calc worksheet is always in grid format, i.e. in tabular format, still it allows you to do insertion and deletion of cells, rows and columns as and when required.
Inserting Cells
For inserting one or more cells in your worksheet, do the following steps :
1. Select as many number of cells as you want to insert in your worksheet.
2. Click on Sheet tab → Insert Cells. Insert Cells dialog box will appear. Its options are Shift cells down, Shift cells right, Entire row and Entire column.
3. Now, choose the option as per your need.
4. Click OK button.
Inserting Rows/Columns
Before inserting a row/column in a worksheet, you need to select that row/column which you want to insert, the new row/column above or left.
For inserting one or more rows/columns in your worksheet, do the following steps :
1. Select as many numbers of row/column as you want to insert in your worksheet.
2. Right click on the mouse, a context menu will appear. Select Insert Rows Above or Insert Rows Below for inserting rows.
Select Insert Columns Before or Insert Columns After for inserting columns.
Deleting Cells
For deleting one of more cells in your worksheet, do the following steps :
1. Select as many number of cells as you want to delete from your worksheet.
2. Click on Sheet tab → Delete Cells. Delete Cells dialog box will appear. Its options are Shift cells up, Shift cells left, Delete entire row(s) and Delete entire column(s).
3. Now, choose the option as per your need.
4. Click OK button.
Deleting Rows/Columns
For deleting one or more rows/columns in your worksheet, do the following steps :
1. Select as many number of rows/columns as you want to delete from your worksheet.
2. Right click on the mouse, a context menu will appear. Select Delete Rows/Columns option.
AutoFill : A Range
LibreOffice Calc supports with an excellent and time saving feature called AutoFill. Using this feature, you do not need to fill manually pattern specific data series in multiple cells in a sequence.
There are two methods of using this feature :
Method 1 Using Fill Handle
For filling a series using Fill Handle, do the following :
1. Click the cell from where the text series is to be started.
2. Type the first entry of the text series in the selected cell. And, next entry in the adjacent cell.
3. Select both the cells.
4. Click the Fill Handle and drag it over to the number of cells to be filled.
Method 2 Using Fill Button of Editing Group
This option copies (repeats) the information from one cell to another. For filling a series using Fill button, do the following :
1. Type the information (cell contents or formula) in the first cell of the group.
2. Starting with the cell containing the contents to be copied, select the group of cells to be filled.
3. From menu bar, select the Sheet tab.
4. Click Fill Cells → select the appropriate option.
| Option | Description |
|---|---|
| Down | Repeats the contents of the first cell throughout the selected cells below it. |
| Right | Repeats the contents of the first cell throughout the selected cells to the right of it. |
| Up | Repeats the contents of the first cell throughout the selected cells above it. |
| Left | Repeats the contents of the first cell throughout the selected cells to the left of it. |
| Sheets | Repeats the contents of the selected cells in another selected worksheet. |
| Series | Fills the data that is part of a pattern, rather than simply repeating the data across selected cells. This option brings up the Fill Series dialog box, which allows you to select the type of pattern you would like to use. e.g. if the first cell contains the day Sunday, Calc will fill the following cells with Monday, Tuesday etc. |
(v) Optional If you select the Series option, then Fill Series dialog box will appear.
(vi) Now, choose the option as per your need.
| Field | Description |
|---|---|
| Direction | Determines whether the series Down, Left, Right and Up. |
| Series Type | Determines whether the additional information will differ from the previous entry by a specific interval (Linear), by multiplying the previous entry by a specific value (Growth), by creating a series of dates according to the selected date format (Date) or by automatically detecting, what type of fill you would like to apply (AutoFill). |
| Time Unit | When Date is selected as the type, determines whether numbers are listed for each day (Day), in the weekday (Weekday), for that day of every month (Month), or for that day of every year (Year). |
| Start Value | Determines a value at which the series should be continued. |
| End Value | Determines a value at which the series should no longer be continued. |
| Increment | When Linear or Growth is selected as the type, determines the amount that the previous value is added to or multiplied by to come up with the results for the next cell. When Date is selected as the type, it determines how many dates should be skipped between each recorded value. |
(vii) Click OK button. The fill will be applied.
Sorting and Filtering
Sorting and filtering provide you to manipulate the worksheet data.
Basic Sorting
To use ascending or descending sort which depends on one column follow the given steps :
1. Select those cells, which you want to sort.
2. Click on Sort Ascending (a to z) button or Sort Descending (z to a) button from standard toolbar.
Custom Sorting
To use ascending or descending sort which depends on more than one columns follow the given steps :
1. Select those cells, which you want to sort.
2. Click on Sort option from standard toolbar. Sort dialog box will appear.
3. Select first column from Sort Key 1 as ascending or descending, second from Sort Key 2 as ascending or descending and so on.
4. Click OK button.
Filtering
It allows you to display the specific data . To filtering follow the given steps :
1. From this menu, select those column(s) (which you want to filter).
2. Select AutoFilter from standard toolbar.
3. Arrow sign will display the right side of first cell in selected columns.
4. Click on arrow and select those words which you want to filter.
5. Click on Not Empty to clear.
Freezing Panes
If you have long rows or columns of data that extend beyond the viewable area of sheet, you can freeze some rows or columns which allows you to see the frozen columns or rows as you scroll through the rest of the data.
1. Select the row below or column to the right of the last column that you want to be in the frozen region. All rows above or all columns to the left of the selection are frozen.
2. Choose View → Freeze Cells → Freeze First Column or Freeze First Row. To deactivate, choose View→Freeze Cells→ Freeze First Column or Freeze First Row again.
Note
Freeze First Column To lock the first column.
Freeze First Row To lock the first row.
Freeze Rows and Columns To lock several rows/columns.
Formulas, Functions and Charts
In LibreOffice Calc, for doing various calculations in the cells of worksheet, formulas (or functions) are used and to display the data in graphical form charts are used.
Using Formulas
Formulas are equations that perform calculations on values in your worksheet. It is an order of values, names, cell references, functions and operators in a cell that together give a new value. A formula always begins with equal (=) sign. e.g. if user wants to display the sum of A5, B5, C5 and D5 in cell E5, user has to enter a formula ' = A5 + B5 + C5 + D5' in a cell E5.
Formula Operators
There are four different types of formula operators: arithmetic, comparison, text concatenation and reference.
Arithmetic Operators To perform basic mathematical operations such as addition, subtraction, multiplication, combine numbers and produce numeric results, arithmetic operators are used. Some arithmetic operators and their meaning are as follows :
| Arithmetic Operators | Meaning |
|---|---|
| + (plus sign) | Addition |
| − (minus sign) | Subtraction or Negation |
| * (asterisk) | Multiplication |
| / (forward slash) | Division |
| % (per cent sign) | Per cent |
| ^ (caret) | Exponentiation |
Comparison Operators You can compare two values with the following operators. When two values are compared by using these operators, the result is a logical value either TRUE or FALSE. Some comparison operators and their meaning are as follows :
| Comparison Operators | Meaning |
|---|---|
| = (equal sign) | Equal to |
| > (greater than sign) | Greater than |
| < (less than sign) | Less than |
| >= (greater than or equal to sign) | Greater than or equal to |
| <= (less than or equal to sign) | Less than or equal to |
| <>, != (not equal to sign) | Not equal to |
Text Concatenation Operator Use the ampersand (&) to concatenate (combine) one or more text strings to produce a single piece of text.
| Text Operator | Meaning |
|---|---|
| & (ampersand) | Connects or concatenates two strings to produce one continuous text value. |
Reference Operators To combine the range of cells for various calculations, reference operators are used. Some reference operators and their meaning are as follows :
| Reference Operators | Meaning |
|---|---|
| : (colon) | Range operator which produces one reference to all the cells between two references. |
| , (comma) | Union operator which combines multiple references into one reference. |
| (space) | Intersection operator which returns a reference to the cells common to the ranges in the formula. |
Order of Evaluation of Formula
Results provided by the formulas are depend on the preferences of operators. Preferences of operators are as follows :
1. : Range reference
2. − Negative Number
3. % Percentage
4. ^ Exponentiation
5. * Multiplication
6. / Division
7. + Addition
8. − Subtraction
9. & Concatenation
10. =, <>, <=, >=, > or < Comparison
Displaying Formulas
To show the formula which is entered in a cell, follow the given steps :
1. Select the cell where formula has entered.
2. Click on View tab → Show Formula.
Function
It is a predefined formula that performs calculations using specific values in a particular order. e.g. SQRT ( ), LOWER ( ), etc. Functions make it easy to perform common calculations on data. In order to use these functions correctly, you need to understand the different parts of functions.
The Parts of Function
Each function has a specific order, called syntax, which must be followed for the function to work correctly.
The basic syntax to create a formula with function is
1. to insert an equal sign (=).
2. a function name (e.g. SUM).
3. an argument that contains the information related to formula to calculate such a range of cell references.
Function Categories
In LibreOffice Calc, functions are categorised into following groups :
Text Functions These functions are used to remove extra characters, e.g. TRIM, CLEAN, etc.
Logical Functions These functions are performed boolean operations on given data, e.g. AND, OR, NOT, etc.
Date and Time Functions These functions are used to create date and time, e.g. DATE, TIME, DATE VALUE, etc.
Financial Functions These functions are used to calculate financial calculations such as investment valuations, interest rate. e.g. FV, PV, RECEIVED, etc.
Maths and Trigonometry These functions perform mathematical calculations including arithmetic, sum, products and trigonometry.
e.g. PRODUCT, MOD, TAN, etc.
Information Functions These functions provide the information about error in formula or data value.
e.g. ISERROR, ISNA, etc.
Engineering Functions These functions are used to perform calculations related to complex numbers, bessel functions, etc., e.g. CONVERT etc.
Lookup and References Functions These functions are used to perform operations on data array.
e.g. VLOOKUP, MATCH, etc.
Database Functions These functions are used to calculate the average, maximum or minimum value from the database list. e.g. DMAX, DCOUNT, etc.
Statistical Functions These functions are used to find the largest and the smallest value from a list of data values. e.g. MAXA, LARGE, etc.
Some Useful Functions
Some useful functions in Calc are listed below :
| Functions | Description |
|---|---|
| SUM | Returns the sum of a list of supplied numbers. |
| AVERAGE | Returns the average of a list of supplied numbers. |
| MAX | Returns the largest value from a list of supplied numbers. |
| MIN | Returns the smallest value from a list of supplied numbers. |
| FACT | Returns the factorial of a given number. |
| INT | Rounds a number down to the next integer. |
| ROUND | Rounds a number up or down, to a given number of digits. |
| TRIM | Removes duplicate spaces and spaces at the start and end of a text string. |
| FIXED | Rounds a supplied number to a specified number of decimal places and then converts this into text. |
| VALUE | Converts a text string into a numeric value. |
| MID | Returns a specified number of characters from the middle of a supplied text string. |
| AND | Test a number of user-defined conditions and returns TRUE if all of the conditions evaluate to TRUE or FALSE otherwise. |
| OR | Test a number of user-defined conditions and returns TRUE if any of the conditions evaluate to TRUE or FALSE otherwise. |
| IF | Test a user-defined condition and returns one result if the condition is TRUE and another result if the condition is FALSE. |
| DATE | Returns a date from a user-supplied year, month and day. |
| COUNT | Counts the number of cells that contain numbers and numbers with the list of arguments. |
| TIME | Returns a time, from a user-supplied hour, minute and second. |
| VLOOKUP | Looks up a supplied value in the first column of a table and returns the corresponding value from another column. |
| INDEX | Returns a reference to a cell (or range of cells) for requested rows and columns within a supplied range. |
| TRANSPOSE | Performs a transpose transformation on a range of cells (i.e. transforms a horizontal range of cells into a vertical range and vice-versa). |
| SUMIF | Adds the cells in a supplied range, that satisfy a given criteria. |
| SUBTOTAL | Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set. |
Now, some commonly used functions in LibreOffice Calc in detail are as follows :
SUM Function
This function, as clear from name, is used to add all the values provided as argument and to display the result in the cell containing function.
Argument Type All Numbers
Return Type Number
Syntax = SUM(number1, number2, .....)
e.g. if you want to display the sum of values of cells A1, A2, A5 and A6 in cell A9, then you need to simply type = SUM(A1,A2,A5,A6) in cell A9 and press Enter.
The sum will be displayed in cell A9. If you want to add a range of values, then provide that range in SUM function as an argument.
e.g. if you want to add values from A1 to A5, then write like = SUM(A1:A5).
Note If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values or text in the array or reference are ignored.
AVERAGE Function
This function calculates the average of all the values provided as argument to this function.
Argument Type All Numbers
Return Type Number
Syntax = AVERAGE(number1, number 2,...)
e.g. to calculate the average of the values of range starting from A1 to A5 in cell B9, you need to write = AVERAGE(A1:A5) in cell B9.
COUNT Function
This function counts the number of cells that contain numbers and numbers within the list of arguments.
Argument Type Any Type
Return Type Number
Syntax = COUNT(value1, value2, .....)
e.g. if the values contained in cells A1, A2, A3 and A4 are 5, 7, TRUE and 10 respectively, then = COUNT(A1:A4) will return 3.
MAX Function
This function is used to return maximum value from a list of arguments.
Argument Type All Numbers
Return Type Number
Syntax = MAX(number1, number2, .....)
e.g. if the values contained in cells A1, A2, A3 and A4 are 5, 7, 2 and 10 respectively, then = MAX(A1:A4) will return 10.
Note Max will consider only numeric and logical values to compute maximum.
MIN Function
This function is used to return minimum value from a list of arguments.
Argument Type All Numbers
Return Type Number
Syntax = MIN(number1, number2,.....)
e.g. if the values contained in cells A1, A2, A3 and A4 are 5, 7, 2 and 10 respectively, then = MIN(A1:A4) will return 2.
Charts
These are the graphical and pictorial representation of worksheet data.
In Calc, charts are created by using Insert tab. LibreOffice Calc supports charts, graphs or histograms generated from specified groups of cells. The generated graphical component can either be embedded within the current sheet, or added as a separate object.
Different Types of Charts
Different types of charts are as follows :
Column Chart
Values are display in the form of vertical columns in this chart. Many different data series and their values are display on X-axis and Y-axis, respectively.
Bar Chart
Categories are listed vertically, so that bars appear on the horizontal, thus there is less emphasis on time flow.
Line Chart
Line chart tends to emphasize the rate of change rather than volume of change over time.
Pie Chart
Only one data series can be plotted, making up 100%. They are used to compare the size of the parts with the whole.
Area Chart
They are used to compare the changes in volume of a data series over time, emphasizing the amount of change rather than the rate of change.
Scatter Chart
They are useful, if the data on the X-axis represent uneven intervals of time or increments of measurement.
Components of a Chart
A sample chart has these components: Chart Title, Gridlines, Plot, Legends, Data Series, Data Label, X-axis, Y-axis, and the X-axis and Y-axis titles.
Now, components of a chart in detail are as follows :
1. X-axis is a horizontal axis known as category axis.
2. Y-axis is a vertical axis known as value axis.
3. Data Series is the set of values you want to plot in the chart.
4. Chart Area is the total area of the chart.
5. Legends is a unique color or pattern, which helps you to identify an individual data series.
6. Chart Title is the descriptive text aimed at helping user to identify the chart.
7. Axis Titles are the titles given to three axis i.e. X, Y, Z.
8. Gridlines are horizontal and vertical lines which are inserted in the chart.
9. Data Label provides additional information about a data marker.
Creating Chart
Steps to create a chart are as follows :
1. Select the data you want to summarise visually and then click on the Insert tab. A context menu will appear.
2. Choose Chart option. Chart Wizard dialog box will appear.
3. Select Chart Type as Column, Bar, etc., and choose the desired option in Normal. Click on Next button.
4. Select a Data Range and click on Next button.
5. Change the order of data using Add or Remove button. Click on Next button.
6. Choose Title, legend and grid settings and click on Finish button.
AutoSum
AutoSum in LibreOffice Calc can perform automatic summation only continuous row or column range. Here, it will search a range to the vertically upwards and to the horizontally left.
But since, in fact, it just insert the SUM function with the range as an argument and leaves it open for editing, this function is often convenient, especially if you prefer to work with the mouse.
There is icon with the image of the Greek letter sigma (Σ) on the formula bar. Clicking on this icon activates the AutoSum.
Shortcut Keys for LibreOffice Calc
| Shortcut Keys | Effect |
|---|---|
| Ctrl+X | Cuts out the selected elements |
| Ctrl+C | Copies the selected items |
| Ctrl+V | Paste from the clipboard |
| Ctrl+Alt+Shift+V | Paste unformatted text from the clipboard. The text is pasted using the format that exists at the insertion point |
| Ctrl+Shift+V | Opens the Paste Special dialog box |
| Ctrl+A | Selects all |
| Ctrl+Z | Undoes last action |
| Ctrl+Y | Redoes last action |
| Ctrl+Shift+Y | Repeats last command |
| Ctrl+I | The Italic attribute is applied to the selected area. If the cursor is positioned in a word, this word is also marked in italic. |
| Ctrl+B | The Bold attribute is applied to the selected area. If the cursor is positioned in a word, this word is also put in bold. |
| Ctrl+U | The Underlined attribute is applied to the selected area. If the cursor is positioned in a word, this word is also underlined. |
| Spacebar | Toggles row selection, except when the row is in edit mode. |
| Ctrl+Spacebar | Selects the current column |
| Shift+Spacebar | Selects the current row |
| Ctrl+O | Opens a document |
| Ctrl+S | Saves the current document |
| Ctrl+N | Creates a new document |
| Ctrl+Shift+N | Opens Templates and Documents dialog box |
| Ctrl+P | Prints document |
| Ctrl+F | Activates the Find toolbar |
| Ctrl+H | Opens the Find & Replace dialog box |
| Ctrl+Shift+F | Searches for the last entered search term |
| F1 | Starts the LibreOffice Help In the LibreOffice Help: Jumps to main help page |
| F10 | Activates the first menu (File menu) |
| Shift+F10 | Opens the context menu |
| Ctrl+Q | Exits application |
| Ctrl+Home | Moves the cursor to the first cell in the sheet (A1) |
| Ctrl+End | Moves the cursor to the last cell in the sheet that contains data |
| Home | Moves the cursor to the first cell of the current row. |
| End | Moves the cursor to the last cell of the current row. |
| Shift+Home | Selects cells from the current cell to the first cell of the current row. |
| Shift+End | Selects cells from the current cell to the last cell of the current row. |
| Shift+Page Up | Selects cells from the current cell up to one page in the current column or extends the existing selection one page up. |
| Shift+Page Down | Selects cells from the current cell down to one page in the current column or extends the existing selection one page down. |
Free study material for Computer Science
Computer Science Exam Resources: 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
Each resource draws directly from authorized textbooks to maintain academic accuracy. Evaluating solved examples allows students to master the formal presentation and answer-writing standards expected in upcoming school exams.
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.