Need to remember the order of operations? Don't retake high school math (blech)! Use this cheat sheet instead!

**Intermediate Excel Cheat Sheet**

__Order of Operations__

o

**PEMDAS**: Do what is in parentheses first! Then exponents, multiplication, division, addition,subtraction

__Formulas:__

- Labels - text, words
- Constants - just a number
- Formulas - a mathematical equation used to calculate

**Steps for Creating Formulas:**

1. Type the equal sign

2. Type the cell names or click on the cells you will be using for the formula, and add the appropriate formula symbol

3. Press the ENTER key

Example: = A1+A2

(This formula will add the contents of cells A1 and A2)

**Use Cell Addresses When Creating Formulas:**

-The point of Excel is to write formulas in a way that allows you to change the data without having to change the formulas themselves.

-To do this, you need to tell Excel which cell the data is located in. A cell's location in the spreadsheet is referred to as its cell reference.

-To find a cell reference, simply look at the column headings to find which column the cell is in, and across to find which row it is in. You can also refer to the number box.

__Auto Sum__

**This shortcut button helps you to: add a set of numbers faster, find the average of a set of numbers**

1. First click in the cell you want the sum/ answer to appear

2. Then click the AutoSum command icon in the Editing Group of the Home Tab. (image above) if you are averaging, make sure you click on the dropdown arrow next to the AutoSum icon to change what the function will do.

3. Select the text you wish to add or average, or click on the cells you wish to add to the AutoSum function, and then add in the operator.

4. Press the ENTER key to calculate the formula when you finish.

__Functions (Fx)__

**Predefined formulas that perform calculations using specific values in a particular order**

1. Click on the empty cell where you want the return value or answer to go

2. Click on the

__“insert function”__command in the Function Library Group of the Formulas Tab, or the icon next to the formula bar (image above).3. In the

__Insert Function dialog box__that appears, type in a description of your function, such as round, or square root in the__“search for function” box__, then press the__“go”__button4. Click on the appropriate function when it appears below in the

__“select a function” box.__Then press the__“ok”__button5. Enter in the function arguments using cell addresses in the

__function arguments dialog box__that appears, then press the__“ok”__button

Supporting files:

Tip Type: