Unit III Spreadsheet Introduction to Spreadsheet VisiCalc ("Visible Calculator") was the first spreadsheet for personal computers, originally released for the Apple II by VisiCorp. It is considered that VisiCalc turned the microcomputer from a hobby for computer enthusiasts into a serious business tool, prompting IBM to introduce the IBM PC, two years later. It was sold over , copies in six years, and as many as million copies over its history. First Spreadsheet .
. Features of OpenOffice Calc: • Connecting with Excel - Ability to open, edit, and save Microsoft Excel spreadsheets. • AutoSum - helps you to add the contents of a cluster of adjacent cells. • List AutoFill - automatically extends cell formatting when a new item is added to the end of a list.
• AutoFill - allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text. AutoFill can also be used to copy functions. You can also alter text and numbers with this feature. • Charts - helps you in presenting a graphical representation of your data in the form of Pie, Bar, Line charts and more.
• Functions - which can be used to create formula to perform complex calculations on data • Database functions - to arrange, store, and filter data . Creating a new worksheet A new worksheet can be created through various methods. From Windows, select Start → All Programs → OpenOffice → OpenOffice Calc (or) From Star Center (Welcome Screen): Double-click on “OpenOffice” icon the desktop Now, a welcome screen appears as shown in Figure . .
This open screen is called as “Star Center” . Calc is one of the component of OpenOffice. So, it may be invoked from the “Star Center” by simply clicking on the “Spreadsheet” icon . (or) A new spreadsheet can also be created by selecting File → New → Spreadsheet from any OpenOffice Application.
After using any one of the above said methods, OpenOffice Calc window appears as shown in Figure . . The outline of the window is very similar to other application windows