# How Do I Complete Formulas And Functions?

Below are instructions on how to enter formulas and functions into an excel spreadsheet.

## In cell E6 write your own formula for the total cost of pencils

1. **Click** into **cell E6**.

2. **Start** a **formula (or function)** by **inserting** an **equal sign (=)**.

3. **Click (or type)** what **cell** you want to **use** in the **equation**. To **find** the cost of **pencils** **click** **cell C6**.

4. To **multipy** the numbers in **two different cells**, **insert** an **asterisk (*)**.

5. **Click (or type)** the **cell **you want to muliply. To find the cost of pencils **click cell D6**.

6. Once your equation is complete, **press enter**. You can see the equation you **entered **in the** box shown above**.

## Apply to all items

1. **Click** on the **green square** in the corner.

2. **Drag** the **square** as far down as needed.

## In cell E17 use the Sum function to add the dollar amounts in Column E

1. **Click** into **cell E17**.

2. **Insert** an **equal sign (=)**.

3. To **use** a **function**, start **typing SUM** after the equal sign.

4. **Click and drag** for whatever **cells** you want to **use** in the **function**.

## In cell E19, calculate the ending balance based on the starting balance of $4,000

1. **Click** into **cell E19 **and **enter** an **equal sign (=).**

2. Start your equation with $4,000 by **clicking** into **cell E2**.

3. **Enter** a **subtraction sign (-)**.

4. **Select E17** and **click enter** to **find** the **ending balance**.

## Change the text to green, bold

1. **Click** into **cell E19**.

2. **Select** the **icon** shown above to **change** the **font color**.

3. **Select** the **icon **shown above to **bold** the **font**.

## In cell F6 write your own formula to show the percentage of the starting total balance for the total cost of pencils (the percentage $71.30 is of the original $4,000)

1. **Click** into **cell F6 **and **enter** an **equal sign (=)**.

2. **Click** into **cell E6**.

3. **Insert **a **slash symbol (/) **to represent division.

4. **Insert** cell **E3**.

Notice in the image that I **entered** **money signs** into the equation. If you want to **keep** a **specific cell **in the equation the same even when you **apply** it to **other cells**, entering the money sign allows you to do so. **Enter ($)** then the **column letter**, then **($)** and the **row number**.

## Apply to all rows

(Make sure to **use** the **information in the blue box** above. Otherwise the information in **cell E3 will have **to be** entered into every equation**.)

1. **Click** on the **small, greeen square** in the corner.

2. **Drag** the **square **down as long as needed.

Keep in mind that formulas and functions are different. If it specifies to use a formula, use your own equation to get the desired result. Functions are formulas already built into excel (such as SUM and AVG).

Created by Mallory