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-/
