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.
Using Different Types of Data
Numbers has a discriminating nose for data. It can sniff out the difference, for example, between numbers and names in your grade book, or between dates and checkboxes in your to-do list. For Numbers, this data detection isn’t just a fussy party trick, it’s a job requirement. When you start sorting your data down the road and, especially, when you start building formulas and charts based on your data, Number has to know when you’re giving it numbers to crunch, text to sort, or dates to schedule. Numbers sees the world in five shades of data:
Ordinary text. This data type includes headings, notes, descriptions, or any text that Numbers can’t place as one of the other data types.
Numbers. This data type is the main ingredient of most spreadsheets and includes prices, integers, fractions, percentages, and any other type of numeric data. Numbers offers lots of different display options for numbers.
Dates and times. This data type includes calendar dates (like December 6, 2009), time of day (like 12:26 p.m.), and the combination of both (December 6, 2009, 12:26 p.m.). You can enter and display this info in a variety of formats.
Time duration. A length of time, like weeks, hours, or even milliseconds.
True or false values.This on-or-off data type is also known in nerd circles by its chirpier name, Boolean values. Behind the scenes, these values are either TRUE or FALSE (in all caps), but you’ll typically see them in Numbers spreadsheets as a simple checkbox (see ...
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.