To do division in Excel you use the front slash character. You can click on the cell you want the formula in, and then you can type it like:
=B1/E4
This will divide the amount in B1 by the amount in E4.
You can use a cell and a value, like this:
=B2/10
or
=200/B5
In Excel, as in other areas of computing, the front slash is used for division. That is why it is on the Numeric keypad on a computer, along with the * for multiplication and the plus and minus signs. The front slash is also known as the solidus. To divide 10 by 5 you would type the following formula.
=10 / 5
Just use the / in the formula like this:
=A2/A3
That divides the value in A2 by the value in A3.
For the basic operations, you use the following symbols:
+ for addition
- for subtraction
* for multiplication
/ for division
Open Office comprises the following programs :- Word - Word-processing Calc - Spreadsheet Base - Database Impress - Slideshow Draw - Graphics Math - Formula
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.
It will find a number - if the number is not a formula. For example - if you search for the number 30 it will find it - BUT - if the product in a cell is the result of a formula it will disregard it.
Try Star Office or Open Office, both of which are free. See the links below.
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.