# Numbers

## Contents

# Benefits and Wonder of Numbers

**Numbers** is a great place to create charts, collect data, and streamline calculating data.

# Getting Started

Similar to Apples other programs, the **Inspector** will be one of the most important tools for editing and formatting your data.

## Familiar Features

There is a lot of built in redundancy within Apple's Products; if you know how to use one it will greatly aid you in the other. Some of the overlap includes:

- The
**Inspector**

- The main menu of the program

## Good practice

- Format your cells to function for your needs
- Set the framework of your document
- Select large groups of cells to make dramatic edits over large areas

# Inserting Formulas

**Numbers**has a lot of different equations pre-loaded and ready to you- To use a formula select the data you want to equation to apply to, then select an applicable formula. The result will appear in the cell immediately to the right (unless otherwise designated)
- You can select equations through the
**Function**button on the toolbar

- When you click the function button, a drop down emerges and allows you to find most equations you will need
- At the bottom of the drop down menu there is a selection called
**Show Function Browser**

- After you use a formula it will show up on your
**Formula List**which attempts streamline your workflow

**Formula List**Also functions similar to**Track Changes**in**Pages**

## Writing Equations

To write a custom equation:
**1.** Select the cell that you want the answer to appear, and type an **=**
**2.** Select the cells with the data you want to analyze, **Numbers** defaults to treat data as a **Sum**
**3.** To do equations other than **Sums**, select data points individually by holding **Command** and clicking the applicable cells one at a time, inserting the mathematical symbols

- Addition (
**+**) - Subtraction (
**-**) - Multiplication (
*****) - Division (
**/**) - Exponentials-Powers (
**^x**) - Exponentials-Roots (
**^(1/x)**)

**Note**:

- When working this way don't forget
**PEMDAS**/**P**lease**E**xcuse**M**y**D**ear**A**unt**S**ally **P**arenthesis,**E**xponentials,**M**ultiplication,**D**ivision,**A**ddition,**S**ubtraction

# Formatting Cells

Cells can be formated using the **Inspector**

With **Formatting Cells** you can designate to work with money, dates, fractions and many others. This is similar to choosing a template in **Pages**, except you can format different cells differently within a document.

## Cell Functions

# Creating Charts

To create a chart you want to select the applicable data and press the **Chart** button on the toolbar or within the **Inspector**

- The symbol looks like this

- When you choose to create a chart a list of chart types will appear. Choose wisely.

## Customizing Charts

Much of the chart customization occurs in the **Inspector**

- You can edit the
**Axis**individually (labeling, and adjusting their scale)