**Share This On Your Site**

## The printable Excel cheat sheet

**Excel can be used to prepare data, do math, and even run small businesses. With a few simple tools, you too can work wonders.**

** The Basics**

1.)

A function = a predefined formula

Ex.

Sum = add cells

Average = find the mean of cell

Count = count a number of cells

INT = round off decimals leaving integers

Round = rounds to a specified number of digits or decimals

And hundreds more.

So you’ve chosen a function, now how do you use it?

2.)

Syntax = the way in which you must format a function for it to work

First an equal sign (=)

Then, the function name (SUM)

Then, the argument (B3:B12)

3.)

The argument = the information you want the function to calculate

+ = Add

– = Subtract

* = multiply

/ = divide

^ = exponent

( )’s = organization for order of operations

B3,E4,… commas seperate elements

B3:B45 colons denate ranges of cells

$ = makes references absolute

Order of operations

Excel treats multiplication and division of equal importance, as well as addition and subtraction

() Parentheses

^ Exponents

* or / from left to right

+ or – from left to right

4.)

References

When pasting formulas somewhere else,

1.)=A1 = relative reference

2.)=$A1 = Column is absolute, row is relative

3.)=A$1 = Row is absolute, column is relative

4.)=$A$1 = Everything is absolute

Relative references adjust to their new surroundings.

[Format: Cell name:Contents]

–B2:4

–B3:5

–C3:=B2+6

Paste C3 to C4…And

–C4:11

The relative reference in C3 tells excel that you want to reference the cell to the left and up one.

You can drag formulas down to fill up entire rows or columns

–A1:5–B1:=sum(A1:A5)

–A2:5–/

–A3:5–/

–A4:5–/

–A5:5–/

–A5:0–/