Page 244 - open office
P. 244
Do you know?
isiCalc was the first spreadsheet package that was introduced in 1 . ater, otus 1-2-3 , uattro
Pro’, ‘Excel’, ‘Calc’, etc. were also developed as spreadsheet packages.
ibreOffice Calc, MS-Excel and OpenOffice Calc are the common spreadsheet packages that are used today.
OpenOffice Calc has been developed by Sun Microsystems. It is available free of cost and can be easily
downloaded from www.openoffice.org.
PARTS OF A WORKBOOK SCREEN
To open Calc in Windows, double-click on its icon on the desktop screen or in inux , click on the OpenOffice
Calc from ‘Panel’. ‘Calc’ opens with a blank workbook as:
Control Close
Button
Maximize/
Menu Bar Restore
Name Box Minimize
Active cell
Title Bar
Formatting Tool Bar Standard
Tool Bar
Sheet Tab Formula Bar
Vertical
Scroll Bar
Sheet Tab Horizontal
Scroll Bar
et us now learn about the various parts of a workbook screen.
Workbook and Worksheet
A workbook consists of worksheets. Worksheet is the working area or page on the screen. A worksheet
consists of rows and columns. (A workbook is like a book and worksheet is like a page of a book). By default, a
workbook opens with three worksheets namely Sheet1, Sheet2 and Sheet3. 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 worksheet. The active sheet i.e. the sheet being used, is highlighted. In the above figure,
Sheet1 is the active worksheet.
Rows
Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position. They are
numbered from top to bottom along the left edge of the worksheet. There are 1 ,4 ,5 6 rows in a worksheet
of Calc.
Columns
Columns are the vertical set of rectangular boxes that are placed adjacent to each other. Columns are labelled
from left to right. There are 1 24 columns available in Calc.
244 Touchpad Information Technology-IX

