EdTech Help GuidesED206 Excel TCAHow Do I Complete Formulas And Functions?

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

0 Comments

Add your comment

E-Mail me when someone replies to this comment