There are actually two programs built in. Some of these questions seem to relate to one (Calc) and other questions seem to relate to the other program (Math).
On Friday 21 January 2011 01:11, 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. Worksheets are the domain of "Calc" which is the OpenOffice.org equivalent of Microsoft Office Excel. There are differences. > 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? A9 in a sheet is a refence to a cell. To explain it simply start OpenOffice.org Calc: 1. Type "6" into cell B2 then tap the [Enter] key. 2. Type "3" into cell D4, [Enter]. 3. In cell E2 type the formula "=B2+D4", [Enter]. 4. In cell F2 type the legend "Cell B2 + Cell D4" 5. In cell E3 type the formula "=sum(b2,d4,e2)" 6. In cell E4 type the formula "=B2*D4" 7. In cell E5 type the formula "=B2/D4" 8. In cell E6 type the formula "=B2-D4" 9. In cell g2 type the formula "=e4*b2/7" > How do I create a power of a number? "=B2^D4" Math is a bit different. It is designed to show your formulas in standard mathematical notation for printing. It does not do any calculations. So to answer this question in the formula editor of Math "a sup b" would be written in the bottom "Commands" window. After a second the layout would appear in the top formula window. The example a and b i gave can be replaced with any letter/s or number/s. > How do I create a fraction? In Calc, format the cells as fractions. From the menu "Format - Cells...", Numbers tab, Category, scroll down and select Fractions. In math, in the Commands window type "a/b" > If anyone can help me, I would be most grateful. Michael Neillis HTH -- Michael --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
