SAMS Teach Yourself Red Hat® Fedora™ 4 Linux® All in One

Q&A

Q1:	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, ...