Formulas in Excel

1. Formulas always begin with an equal sign =


2. Formulas always specify the cells (A2) or numbers (23) needed to calculate the answer.


3. Formulas always use mathematical operations: Addition (+), Subtraction (-), Multiplication (*), and/or Division (/)


4. The use of a semicolon : menas it is a range of numbers. A1:a10 means all the cells between A1 and A10 --- A1,A2,A3,A4,A5,A6,A7,A8,A9,A10

Example:

=A1+A2  this translates to: add whatever is in cell A1(54) to A2 (34).



When you press Enter the formula goes to work and returns the value.



There are almost 400 different formulas.

Here are some you can use:

• =average(cell:cell)      this is the Mean or Average formula, it gives you the sum of the cells divided by the number of cells


• =mode(cell:cell)     this is the Mode formula, it gives you the most frequent number used


• =median(cell:cell)     this is the Median formula, it is the middle number


• =sum(cell:cell)     this Totals the cells, it adds all the numbers together and gives you a total