On 1/20/2011 7:11 AM, FRANCES & MICHAEL wrote:
Hi there forum members!
I am a mathematics teacher. I am trying to construct a mathematics website and
I am trying to produce my own worksheets. I would like to use the Open Office
Mathematics program for these tasks but, unfortunately, I do not understand how
to use it at all well. There are 3 initial questions that I would like to ask
for someone's help with because I cannot work the answers out for myself:
What does, for example, A9 mean?How do I create a power of a number?How do I
create a fraction?If anyone can help me, I would be most grateful.
Michael Neillis
CC'd to OP
A9 means Column A, Row 9
A simple search of the Calc Help File for POWER yields:
Example
=POWER(4;3) returns 64, which is 4 to the power of 3.
=4^3 also returns 4 to the power of 3.
A simple search of the Calc Help File for FRACTION yields:
You can enter a fractional number in a cell and use it for calculation:
Enter "0 1/5" in a cell (without the quotation marks) and press the
input key. In the input line above the spreadsheet you will see the
value 0.2, which is used for the calculation.
If you enter "0 1/2" AutoCorrect causes the three characters 1, / and 2
to be replaced by a single character. The same applies to 1/4 and 3/4.
This replacement is defined in Tools - AutoCorrect Options - Options tab.
If you want to see multi-digit fractions such as "1/10", you must change
the cell format to the multi-digit fraction view. Open the context menu
of the cell, and choose Format cells. Select "Fraction" from the
Category field, and then select "-1234 10/81". You can then enter
fractions such as 12/31 or 12/32 - the fractions are, however,
automatically reduced, so that in the last example you would see 3/8.
--
Gene Young
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
