In an Open Office Spreadsheet, you can perform Sigma (summation) operations by using the SUM function. To do this, select the cell where you want the result to appear, type =SUM(
followed by the range of cells you want to add (e.g., A1:A10
), and then close the parentheses. Press Enter, and the sum of the specified range will be calculated and displayed in the selected cell. Alternatively, you can use the AutoSum feature by selecting the cell below or next to the range and clicking on the Sigma (Σ) icon in the toolbar.
Yes - you can create graphs from the data in a spreadsheet.
Absolutely - I use them regularly. The spreadsheet part of OpenOffice is 'Calc'
Some popular spreadsheet programs are Excel (MS Office), Lotus 1-2-3, and Calc (Open Office).
yes
Microsoft Excel and Open Office Calc
Just about the same as in Microsift Office: Spreadsheet, Word processor, Database, Graphics, Presentation...
The maximum per spreadsheet is 1024 columns.
Open Office will happily open Excel files. You may have to play around with the formatting etc, but it will certainly import the data from an Excel spreadsheet without any problems.
You would use a spreadsheet application such as Excel, Lotus 123, Open Office Calc, Quattro Express, Google Docs, etc. It will depend on what was used to create the original document. Some applications are capable of opening several types of spreadsheet.
Try Star Office or Open Office, both of which are free. See the links below.
Click on Start > All programs > Open office > Calc. That will open a blank spreadsheet for you to start using. If you're referring to a particular function - drop me a note via my message board, and I'll try to help.
Microsoft Excel.