Page 77 - PlugGPT_V2.0_C5_Flipbook
P. 77
Scroll Bar
There are two scroll bars in the Window. The Vertical Scroll bar to move up and
down and the Horizontal Scroll bar to move Right and Left on the worksheet.
Status Bar
This bar gives us the information of the Spread sheet. It has the following information:
Position in the Document Current Page Style
Insert Mode Selection Mode
Document Notification Digital Signature
Standard Formula Zoom level
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 coloured
cell border.
DATA TYPES IN LIBREOFFICE CALC
While working in LibreOffice Calc, following types of data can be entered in
spreadsheet.
Introduction to LibreOffice Calc 75

