Page 183 - CA_165_V2.0_C9_Flipbook
P. 183
l It allows the formulae used for calculations to update automatically when the corresponding data
values change.
Do you know?
VisiCalc was the first spreadsheet package that was introduced in 1979. 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 was originally developed by Sun Microsystems but is now maintained
by The Apache Software Foundation. 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 the ‘Applications’ menu.
Calc opens a blank spreadsheet as shown below:
Close
Menu Bar Maximize/
Restore Down
Name Box Minimize
Active Cell Title Bar
Standard
Toolbar
Formatting
Toolbar Formula Bar
Vertical
Cell Scroll Bar
Row
Column
Sheet Tabs Horizontal
Scroll Bar
Status Bar
Spreadsheet and Sheet
A spreadsheet consists of sheets. Sheet is the working area or page on the screen. A Spreadsheet
consists of rows and columns. (A Spreadsheet is like a book and sheet is like a page of a book). By
default, a spreadsheet opens with three sheets, 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 at the bottom of the spreadsheet. 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 spreadsheet where data (numbers, text, formulas, etc.) are entered. A cell can be selected by
clicking on it, and the selected cell is referred to as the active cell.
Working with Spreadsheet 181

