Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc Notes Set 02

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.

OptionDescription
DownRepeats the contents of the first cell throughout the selected cells below it.
RightRepeats the contents of the first cell throughout the selected cells to the right of it.
UpRepeats the contents of the first cell throughout the selected cells above it.
LeftRepeats the contents of the first cell throughout the selected cells to the left of it.
SheetsRepeats the contents of the selected cells in another selected worksheet.
SeriesFills 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.

FieldDescription
DirectionDetermines whether the series Down, Left, Right and Up.
Series TypeDetermines 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 UnitWhen 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 ValueDetermines a value at which the series should be continued.
End ValueDetermines a value at which the series should no longer be continued.
IncrementWhen 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 OperatorsMeaning
+ (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 OperatorsMeaning
= (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 OperatorMeaning
& (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 OperatorsMeaning
: (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 :

FunctionsDescription
SUMReturns the sum of a list of supplied numbers.
AVERAGEReturns the average of a list of supplied numbers.
MAXReturns the largest value from a list of supplied numbers.
MINReturns the smallest value from a list of supplied numbers.
FACTReturns the factorial of a given number.
INTRounds a number down to the next integer.
ROUNDRounds a number up or down, to a given number of digits.
TRIMRemoves duplicate spaces and spaces at the start and end of a text string.
FIXEDRounds a supplied number to a specified number of decimal places and then converts this into text.
VALUEConverts a text string into a numeric value.
MIDReturns a specified number of characters from the middle of a supplied text string.
ANDTest a number of user-defined conditions and returns TRUE if all of the conditions evaluate to TRUE or FALSE otherwise.
ORTest a number of user-defined conditions and returns TRUE if any of the conditions evaluate to TRUE or FALSE otherwise.
IFTest a user-defined condition and returns one result if the condition is TRUE and another result if the condition is FALSE.
DATEReturns a date from a user-supplied year, month and day.
COUNTCounts the number of cells that contain numbers and numbers with the list of arguments.
TIMEReturns a time, from a user-supplied hour, minute and second.
VLOOKUPLooks up a supplied value in the first column of a table and returns the corresponding value from another column.
INDEXReturns a reference to a cell (or range of cells) for requested rows and columns within a supplied range.
TRANSPOSEPerforms a transpose transformation on a range of cells (i.e. transforms a horizontal range of cells into a vertical range and vice-versa).
SUMIFAdds the cells in a supplied range, that satisfy a given criteria.
SUBTOTALPerforms 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 KeysEffect
Ctrl+XCuts out the selected elements
Ctrl+CCopies the selected items
Ctrl+VPaste from the clipboard
Ctrl+Alt+Shift+VPaste unformatted text from the clipboard. The text is pasted using the format that exists at the insertion point
Ctrl+Shift+VOpens the Paste Special dialog box
Ctrl+ASelects all
Ctrl+ZUndoes last action
Ctrl+YRedoes last action
Ctrl+Shift+YRepeats last command
Ctrl+IThe Italic attribute is applied to the selected area. If the cursor is positioned in a word, this word is also marked in italic.
Ctrl+BThe Bold attribute is applied to the selected area. If the cursor is positioned in a word, this word is also put in bold.
Ctrl+UThe Underlined attribute is applied to the selected area. If the cursor is positioned in a word, this word is also underlined.
SpacebarToggles row selection, except when the row is in edit mode.
Ctrl+SpacebarSelects the current column
Shift+SpacebarSelects the current row
Ctrl+OOpens a document
Ctrl+SSaves the current document
Ctrl+NCreates a new document
Ctrl+Shift+NOpens Templates and Documents dialog box
Ctrl+PPrints document
Ctrl+FActivates the Find toolbar
Ctrl+HOpens the Find & Replace dialog box
Ctrl+Shift+FSearches for the last entered search term
F1Starts the LibreOffice Help In the LibreOffice Help: Jumps to main help page
F10Activates the first menu (File menu)
Shift+F10Opens the context menu
Ctrl+QExits application
Ctrl+HomeMoves the cursor to the first cell in the sheet (A1)
Ctrl+EndMoves the cursor to the last cell in the sheet that contains data
HomeMoves the cursor to the first cell of the current row.
EndMoves the cursor to the last cell of the current row.
Shift+HomeSelects cells from the current cell to the first cell of the current row.
Shift+EndSelects cells from the current cell to the last cell of the current row.
Shift+Page UpSelects cells from the current cell up to one page in the current column or extends the existing selection one page up.
Shift+Page DownSelects cells from the current cell down to one page in the current column or extends the existing selection one page down.

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

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

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.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

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.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

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.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

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.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

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.