MS Excel TUTORIAL/REVIEW
Back | Back To Start | Next
4 Formulas and Functions
Formulas (Mathematical Operations)
- Formulas are entered into the Formula Bar.
- Formulas must begin with an equal sign "=".
Example - Suppose you wanted to add the total amount of money earned in a bake sale.
The formula =B3+B4+B5 means:
Add:
- B3 (Monday's earnings),
- B4 (Tuesday's earnings),
- B5 (Wednesday's earnings)
Basic Functions
Functions can be a faster way of doing mathematical operations than formulas.
Example - if you wanted to add the values of cells D1 through D10, you could type the formula "=D1+D2+D3+D4+D5+D6+D7+D8+D9+D10".
A shorter way would be to use the SUM function and simply type "=SUM(D1:D10)".
Two popular functions and examples are given in the table below:
| Function | Example | Description |
SUM |
=SUM(A1:100) |
finds the sum of cells A1 through A100 |
AVERAGE |
=AVERAGE(B1:B10) |
finds the average of cells B1 through B10 |
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
