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, ... |
Get SAMS Teach Yourself Red Hat® Fedora™ 4 Linux® All in One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.