Page 171 - CA 165 ver 1.0 Class 9
P. 171
l It allows the formulae used to perform calculations to change automatically, when the corresponding
data values change.
Do you know?
‘VisiCalc’ was the first spreadsheet package that was introduced in 1978. Later, ‘Lotus 1-2-3’, ‘Quattro
Pro’, ‘Excel’, ‘Calc’, etc. also emerged as famous spreadsheet packages.
INTRODUCING CALC
MS Excel, Google Sheets and OpenOffice Calc are the most popular and widely used spreadsheet
packages. OpenOffice Calc has been developed by Sun Microsystems. It is available free of cost and can
be easily downloaded from www.openoffice.org.
To begin with Calc in Windows, double click on its icon on the desktop or in ‘Linux’, click on OpenOffice
Calc from ‘Panel’.
‘Calc’ opens a blank workbook as shown below:
Close
Maximize/
Menu Bar Resotre
Minimize
Name Box
Cell Pointer Title Bar
Standard
Formatting Tool Bar
Tool Bar Formula Bar
Cell
Vertical
Scroll Bar
Row
Column
Sheet Tabs Horizontal
Scroll Bar
Status Bar
Workbook And Worksheet
Worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A
workbook is a collection of multiple worksheets. (A workbook is like a book and the worksheet is like
a page of a book). By default, a workbook opens with three worksheets, namely Sheet1, Sheet2 and
Sheet3. User can change the name of the sheets and may 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.
Cells
A rectangular box formed by the intersection of a row and a column is called a cell. Cell is the basic unit
of a worksheet where data (numbers, text, formulas, etc.) are entered. A cell can be selected by clicking
on it. A selected cell is also called an active cell.
Working with Spreadsheet 169

