Excel Functions
A function is a ready-made formula that does a calculation for you. Instead of adding numbers one by one, a function does the work in one step. Every function starts with an equal sign (=).
🧮 SUM Function in Action
| 10 | |
| 20 | |
| 30 | |
| =SUM(A1:A3) |
A1:A3 means "from cell A1 to cell A3"
Common Functions
| Function | What it does | Example |
|---|---|---|
| SUM | Adds numbers | =SUM(A1:A5) |
| AVERAGE | Finds the average value | =AVERAGE(B1:B5) |
| MAX | Finds the largest number | =MAX(C1:C5) |
| MIN | Finds the smallest number | =MIN(D1:D5) |
| COUNT | Counts numbers in a range | =COUNT(E1:E5) |
How to Type a Function
- Click the cell where you want the result
- Type the equal sign =
- Type the function name, like SUM
- Type an opening bracket and select the cells
- Close the bracket and press Enter
Range — A Group of Cells
A range is a block of cells written with a colon, like A1:A5. This means "every cell from A1 to A5." A range saves you from typing each cell name one by one.
🔑 Key Terms
- Function – A ready-made formula that performs a calculation
- Range – A group of connected cells, such as A1:A5
- Argument – The cells or values placed inside a function's brackets
✏️ Exercise
- Which function finds the average of numbers?
- What symbol must every function start with?
- What does the range B1:B4 mean?
© estudy247.com | Junior Computer Skills – Class 5