Work with New Tables in iPad Numbers App - dummies

Work with New Tables in iPad Numbers App

Tables contain the data for your spreadsheets and charts in Numbers for iPad, so it may be a bit surprising if you haven’t created a single table. That’s because you have numerous templates to work with. You don’t have to start from the beginning; instead, you can start from further along in the development process.

Tables can be relatively small and focused. You can use formulas to link them, and that’s a much better strategy than putting every single piece of data into an enormous spreadsheet.

Tables aren’t simply repositories of data; they also drive charts. When you’re organizing data in a table, you may want to consider how to transform it to create the kind of charts you want.

As you’re planning the structure of your tables and sheets, pay attention to the moments when you realize you have to add more data to a table. Ask whether you truly need more data in that table or need a table that can be linked to the first table by a calculation.

A table often has a header row above its data rows; the header row usually contains titles but may also contain calculations such as sums or averages. Numbers tables can have several header rows. A column to the left of the table also has the same functionality — it’s a header column.

People often believe that a header appears only at the top, but in this usage, it appears on whichever side is appropriate.