By Jacek Artymiak
OpenOffice Calc is the main strong and frequent open resource spreadsheet software in lifestyles. it's the basically actual replacement to Excel. Jacek Artymiak is greatly considered as the authority on OpenOffice Calc. he is taking you, step-by-step, from the interface and dealing with Calc documents to operating with facts resources small and massive. Artymiak then extends the reader's skillset to facts visualization, writing complicated formulation and appearing statistical research. starting OpenOffice Calc permits you to achieve self assurance within the thought of use of statistical formulation, yet doesn't imagine familiarity with one other spreadsheet software.
Read Online or Download Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting PDF
Best business technology books
This publication is designed to hide all the features of InfoPath 2010 inside a SharePoint 2010 atmosphere with reference to making and constructing enterprise suggestions. it really is aimed at either technical and semi-technical execs and doesn't require a level in laptop programming to make use of. The scenario-based presentation of the cloth offers not just a very good instructional but in addition an in-depth reference for reaching essential InfoPath 2010 projects in the SharePoint platform.
Every little thing IT pros have to administer their collaborative setting SharePoint starting place 2010 is the latest model of a strong collaboration device utilized in many enterprises. This publication will get community pros and enterprise program directors on top of things on SharePoint Foundation's positive factors, install strategies, and management, getting ready them to create strong collaboration constructions for his or her businesses.
If you happen to contemplate info, do you're thinking that of unending rows and columns in spreadsheets? Excel Dashboards and stories For Dummies, third version exhibits you the way to utilize your facts - and places an finish to mind-numbing spreadsheets via exploring new how one can conceptualize and current key info. there is usually a niche among dealing with information and synthesizing it into significant studies, and this approachable textual content bridges this hole with speedy and available info that solutions key questions, like the way to meaningfully seize information traits, the best way to express relationships in information, and while it really is greater to teach variances than genuine information values.
- Microsoft Excel 2007 For Dummies Quick Reference
- Social Networking for Business: Choosing the Right Tools and Resources to Fit Your Needs
Additional info for Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting
Info CHAPTER 6 ■ UTILITY MATHEMATICAL FUNCTIONS Random Number (RAND) Syntax: RAND() The RAND function returns a random fractional number between 0 and 1. To make it a bit more useful, you can multiply it by 10 and use TRUNC to turn the results into integers from 0 to 10. Here’s an example: =TRUNC(RAND()*10) Multiplying RAND by 100 in the preceding example returns numbers from 0 to 100. Figure 6-6. Sample result of the RAND function If you want random numbers from a different range, such as 1970 to 2010, use the following trick: =TRUNC(RAND()*40)+1970 See also the section on the TRUNC function.
For example: =CEILING(-13; -2) returns –12, which is greater than –13, unless you add 1 as mode to round down, as in =CEILING(-13; -2; 1) which returns –14. You cannot mix negative and positive numbers. For example: CEILING(-13;2) is not allowed. See also the sections on the EVEN, FLOOR, INT, ODD, ROUND, ROUNDDOWN, ROUNDUP, and TRUNC functions. Nearest Even Integer (EVEN) Syntax: EVEN(Number) The EVEN function is useful when you want results to be presented as even integer numbers. 349888)/2 The result will be 6234 pairs of socks, which is a much more useful and natural way to present such quantities.
For example: =POWER(10; 2) returns 100, or 102. info CHAPTER 5 ■ SIMPLE MATHEMATICAL FUNCTIONS Figure 5-7. Sample result of the POWER function See also the sections on the EXP, FACT, LN, LOG, LOG10, and SQRT functions. Product of Many Arguments (PRODUCT) Syntax: PRODUCT(ARG1; ARG2; … ARG30) The PRODUCT function multiplies up to 30 arguments (x1, x2, … x30). Each argument can be a single value or a range of cells. For example: =PRODUCT(A1:A23; B2:C23) multiplies values of all cells from ranges A1:A23 and B2:C23.