Create spreadsheets in Numbers with your iPad


When someone thinks of the iPad, that person has a tendency to think of shredding a game or cruising around on Safari, not wading deep right into a spreadsheet. But if you can't be all play and need to get worksome work done on your trusty tablet, the Numbers app can graph your data, crunch your digits, and handle other nerdy tasks.

Just like Pages, Numbers provides a collection of 16 pre-fabricated templates for the most popular types of spreadsheets: a mortgage calculator, personal budget tracker, travel planner, weight-loss log, expense report, and more. Gleam Blank template with an empty grid of cells awaiting you. Tap a template to select it. Tap the fake text and numbers in the cells to overwrite them. To add new sheets or forms towards the spreadsheet, tap the plus button on the tab at the top of the screen.

Just like Pages, the four icons hanging out in the top-right corner of the screen hold the formatting tools for text and graphics. Having a tap, you can:

Style text, rows, and cells. You get different choices here depending on whether you've selected text or tables. For text, you get a box with Style, Text, and Arrange tabs. Here, you can choose typefaces, colors and effects, and flip objects. If you have a table selected, the menu becomes a four-tabbed box for changing the color and style of the table.

Tabs for Headers and Cells hold the controls for tweaking those elements, and also the Format tab enables you to pick the number configuration, like currency or perhaps a percentage. When you have a chart selected, the menu gives you color and style options for the chart's text and type. In short, if you need to format anything about this sheet, the menu has it.

Add images and graphics. Just as in Pages, this menu holds the tabs to all the photos, tables, charts, geometric shapes you might want to add to your spreadsheet. For instance, you can press and hold a pie chart on the page before Delete button appears, zap the pie chart off the screen, and drag a bar chart out of the menu and onto the sheet to replace it. Then tap or drag a table to add its data to the chart.

Change settings. Tap here to open the Tools menu. The Find option towards the top of the menu lets you search for keywords within the file, but it's the second menu item that should find you solutions to your Numbers questions. This is the link to the online Help guide, where Apple's detailed manual for implementing Numbers hangs out.

Another two items on the Tools menu are Off/On switches for that onscreen Edge Guides that appear to help you align elements as you fingerdrag them around the screen, as well as the program's spell-checker to help catch typos in your charts.

Visit fullscreen view. Tap here to dismiss the toolbar for an uncluttered full-screen look at your sheet. Tap the top of the screen to get it back. You can pull and push pretty much every element in a Numbers template into a different size to accommodate your data set. Need to expand the standard chart by a few rows or columns? Tap the chart and, when the gray bar appears, tap the circular handle on either the vertical or horizontal bar and drag it in the direction you need to include (or delete) rows and columns.

Can't stand where a table or chart is on the template? Tap it so the same gray adjustment bars appear, press the dotted circle in the top-left corner and drag the table to a new location on the page. Need to edit the data the chart references? Provide the old double-tap and when the icon appears at the top of the screen, tap it and choose Plot Rows as Series or Plot Columns as Series.

It would not be a spreadsheet program whether it didn't do sums and calculations. Doubletap any cell you need to execute an automatic calculation and the Numbers keypad for punching in math and logic arguments appears. It provides more than 250 formulas and functions in several mathematical specialties, including engineering and statistics for a value-calculating good time.

Legal Disclaimer

Our website is not responsible for the information contained by this article. Webworldarticles.com is a free articles resource thus practically any visitor can submit an article. However if you notice any copyrighted material, please contact us and we will remove the article(s) in discussion right away.


This article was sent to us by: Colin Bonner at 02262011

Related Articles

1. Expected battery life and charging times for an iPod Touch
Apple says battery life on the new iPod touch, with its bigger battery and advanced technology, should last longer than the previous version. Given battery life durations...

2. How to register or activate your iPod Touch
iPod touch registration Once you have iTunes installed or updated on your computer, you are ready to connect your iPod touch for the first time and get it regis...

3. Useful iPod Touch applications and settings
ipod touch Inside Apps and the Settings Screens Getting around the screens inside the apps on your iPod touch is as simple as tapping on the screen. Tap...

4. How to use the two onscreen keyboards on your iPod Touch
You'll find two onscreen keyboards on your iPod touch: the smaller one visible when you hold your iPod touch in a vertical orientation, and the larger landscape keyboard ...

5. Digital data versus analog data storage
Data with distinct values is called discrete data. Data with continuous values is called analog data. Discrete data stored in binary form is digital. Just think of "dig...

6. Common output devices of a personal computer
A monitor, the most important output device, is a computer display screen. Early monitors displayed white or a single color on a black background, but current monitors ...

7. Main memory in a PC consists of RAM
The main memory in a computer is made of RAM, which stands for Random Access Memory. The term "random access" means the same thing: that the data in the memory can be acc...