Page 216 - IT_Play_V1.0 Class9
P. 216
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.
Status Bar
It lies at the bottom of the screen. It shows the current status of an active application.
Sheet Tab
It lies below the active sheet of the screen. The names of the sheets appear in the sheet tabs at the bottom of
the spreadsheet. Click on the specific sheet tab to open it.
Horizontal Scroll Bar
It lies below the sheet tabs. It helps to view the spreadsheet screen by moving the scroll button from left to
right and vice-versa.
Vertical Scroll Bar
It lies towards the right side of the spreadsheet. It helps to view the spreadsheet by moving the scroll button
from top to bottom and vice-versa.
Control Buttons
Control buttons are essential interface elements that allow users to execute commands, such as minimizing,
maximizing, or closing a window.
RANGE OF CELL
A group of cells is known as a cell range. A range comprises of two or more selected cells and those selected
cells need not be adjacent to each other. Rather than a single cell address, you will refer to a cell range using
the cell addresses of the first and last cell in the cell range separated by a colon. For example, a cell range that
includes cells A1, A2, A3, A4, and A5 would be written as A1:A5. Different types of cell ranges are:
214 Information Technology Play (Ver 1.0)-IX

