QA


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, choose Help, OpenOffice.org Help to open the help system, then read about the Sort and Filter functions in the Data menu.



    SAMS Teach Yourself Red Hat(r) Fedora(tm) 4 Linux(r) All in One
    Cisco ASA and PIX Firewall Handbook
    ISBN: N/A
    EAN: 2147483647
    Year: 2006
    Pages: 311
    Authors: David Hucaby

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net