Page 62 - Web_Application_v2.0_C12_Fb
P. 62
For example, selecting SUM allows you to type the range of cells to sum, such as A1:A5. By default, the
Select Function tool in LibreOffice Calc typically opens with the SUM function selected.
Formula: In LibreOffice Calc, the = symbol initiates a formula or function. It tells Calc to interpret the
following text as a formula rather than a regular piece of text or a number. For example:
• =A1+B1 adds the values in cells A1 and B1.
• =SUM(A1:A5) calculates the total of the values in cells A1 through A5.
The = symbol is essential for enabling calculations and functions in spreadsheet cells.
Input Line: It displays the contents of the selected cell (data, formula, or function). It allows editing of the
cell contents. Click in the area and, then type the changes. To edit within the current cell, just double-click
in the cell.
Spreadsheet and Sheet
A spreadsheet consists of sheets. Spreadsheet is the working area or page on the screen. A Spreadsheet
consists of rows and columns. (A Spreadsheet is like a book and sheet is like a page of a book). By default, a
spreadsheet opens with one sheet namely Sheet1. Users can change the name of the sheets and delete or
add extra sheets if required. The name of each sheet appears in the sheet tab towards the bottom of the
spreadsheet. The active sheet i.e. the sheet being used, is highlighted.
Rows
Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position. They are
20
numbered from top to bottom along the left edge of the spreadsheet. There are 10,48,576 (2 ) rows in a
spreadsheet of LibreOffice Calc. The rows are numbered as 1,2,3,4,... .
Columns
Columns are the vertical set of rectangular boxes that are placed adjacent to each other in a vertical position.
Columns are labelled from left to right. There are 1024 (2 ) columns available in LibreOffice Calc.
10
Cells
A rectangular box formed by the intersection of a row and column is called a cell. Cell is the basic unit of a
spreadsheet where data (numbers, text, formulas, etc.) are entered.
Active Cell
The selected or activated cell is referred to as the active cell which is always highlighted with a thick border.
The address of the active cell is displayed in the name box for example, A1. In a spreadsheet, active cell is the
place where data is entered. Before entering any data in the cell, it has to be first selected by placing a cursor
on it. Then, when we position the mouse cursor on a cell, it gets selected and is ready to take data from the
user or perform editing.
Cell Address
Each cell has a unique address which identifies its location. A cell address is identified with its column
position followed by its row number. For example, ‘A5’ is the cell address that is a combination of column
‘A’ and row ‘5’.
Sidebar
The sidebar in LibreOffice Calc provides quick access to various features, including Properties, Styles, Gallery,
Navigator, and Functions, allowing users to efficiently manage and format their spreadsheets.
60 Touchpad Web Applications (Ver. 2.0)-XII

