Can I mix numbers, cell references, operators like + and -, and functions in a single formula in Calc?
A1:
Yes. In formulas, you can mix numeric elements, operators, and functions in any order. For example, the following formula is valid and works as expected:
=sin(F26/100+G26*1.1)+10
Q2:
I've been told that electronic spreadsheets can also be used to perform some database functions. How can I learn more about this?
A2:
If you're familiar with database concepts, you can use a spreadsheet like OpenOffice Calc to manage tables of data for you. In database terms, each row is a record, and each column in a given row is a field in the record. Data can then be sorted or filtered for display based on the values of fields. For more information, choose Help, OpenOffice.org Help to open the help system, then read about the Sort and Filter functions in the Data menu.