Page 121 - TechPluse_C5_Flipbook
P. 121
Status Bar
This bar gives us the information of the Spread sheet. It has the following information:
a. Position in the Document b. Current Page Style
c. Insert Mode d. Selection Mode
e. Document Notification f. The Digital Signature
g. Standard Formula h. Zoom
Rows
Horizontal line of cells is called a row. A row in Calc spreadsheet is numbered
1,2,3 so on. There are 1,048,576 rows in a Calc spreadsheet, this makes it popular
among large data users. Row numbers are displayed in the Left-hand side as
row header.
Columns
Vertical lines which run through entire spreadsheet are called columns. Columns
are addressed as a, b, c and so on. The Column names are displayed just below the
formula bar in the column header.
Cell
Intersection of a row and a column is called a cell. The entire spreadsheet is filled
with cells which hold the user data.
Cell Address
Cell address is a reference address of a cell. It is combination of column name and
row number. If we say A1 means we are referring to the cell address of First column
and First row. A Cell address is very important part of a Calc Spreadsheet as all the
formula and data entered in a cell is referred as its cell address.
Active Cell
The currently selected cell is called the Active cell. We can identify it by its dark cell
border.
DATA TYPES IN LIBREOFFICE CALC
While working in LibreOffice Calc, following types of data can be entered in
spreadsheet.
Number: It includes the digits (0–9) and their different combinations. All types
of calculations can be done on numbers. By default, the numbers are right
aligned in a cell.
Introduction to LibreOffice Calc 119

