April 2009
Intermediate to advanced
888 pages
40h
English
Content preview from iWork '09: The Missing ManualBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Common Math Functions
Numbers offers a wide range of functions for managing your adventures in arithmetic, including lots of advanced functions tailored for accountants, statisticians, and rocket scientists. Although these brainy beauties are often crucial to folks working in a specific field, these functions are too esoteric for the general public, often requiring specialized knowledge even to understand why you might use them. Some of these topics would require a whole other book (and possibly a graduate degree) to explain. If you wouldn’t know a multinomial coefficient from a multinational coffeehouse, then chances are you’ll never use anything close to all the functions iWork offers. As a result, this book doesn’t delve into these deep, dark nooks and crannies.
Instead, this section provides a review of commonly used math functions. Although this treatment only scratches the surface of the function library’s numerical know-how, you can, as always find a complete list of all iWork formula functions in the Function Browser.
Tip
The Numbers Help menu also includes a handy overview of functions, including introductory material for working with financial and accounting functions. To check it out, choose Help → “iWork Formulas and Functions Help”.
The Quick-Formula Functions and Basic Math
In the last chapter’s review of instant calculations and quick formulas, you met the most popular functions in Spreadsheet Land. SUM, COUNT, MAX, MIN, AVERAGE, and PRODUCT are the most commonly used ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.