0
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.
What else can I help you with?
In open office is it possible to convert a spreadsheet to a graph?
Yes - you can create graphs from the data in a spreadsheet.
Does open office give you the ability to create a spreadsheet?
Absolutely - I use them regularly. The spreadsheet part of OpenOffice is 'Calc'
What spreadsheet programs are popular for business use?
Some popular spreadsheet programs are Excel (MS Office), Lotus 1-2-3, and Calc (Open Office).
Name two spreadsheet programs?
Microsoft Excel and Open Office Calc
Is Microsoft Excel and Open Office Cal are examples of spreadsheet software?
yes
what are the functions of open office?
Just about the same as in Microsift Office: Spreadsheet, Word processor, Database, Graphics, Presentation...
HOW many columns are three in open office calc?
The maximum per spreadsheet is 1024 columns.
How do you open an Excel file in Open Office?
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.
What do you use to open a spreadsheet?
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.
What are other spreadsheet programs other than excel?
Try Star Office or Open Office, both of which are free. See the links below.
How do you use spreadsheet on Open Office 3.0?
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.
What software is used in a spreadsheet?
Microsoft Excel.
