Need to remember the order of operations? Don't retake high school math (blech)! Use this cheat sheet instead!
Intermediate Excel Cheat Sheet
- Labels - text, words
- Constants - just a number
- Formulas - a mathematical equation used to calculate
Steps for Creating Formulas:
1. Type the equal sign
-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.