Functions
A function is a ready-made formula built into Excel. It performs a complex calculation with one short word.
Function structure
=NAME(arguments). For example, =SUM(B2:B5): SUM is the function name and B2:B5 is the argument. Separate multiple arguments with commas (semicolons in some locales).
Must-know functions
SUM adds, AVERAGE averages, MAX and MIN find the largest and smallest, COUNT counts numbers, IF returns a conditional result, VLOOKUP looks things up in a table.
Typing a function
Type = and the start of the name — Excel suggests a list; pick with Tab. After the opening parenthesis an argument tooltip appears.
Tips
- Function names depend on Excel’s language: in Russian Excel SUM is СУММ and IF is ЕСЛИ. You can switch the simulator’s language in settings.
- Detailed guides for each function are in the “Functions” group.
Try it in the simulator
Type =AVERAGE(B2:B5) into B6 and =MAX(B2:B5) into B7. Label A6 and A7.
Книга1 - Excel
—☐✕
Буфер обмена
Calibri ▾11 ▾
Шрифт
Выравнивание
Общий ▾
Число
Стили
Ячейки
Редактирование
✕✓fx
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Student | Score | ||||||||||||||||||||||
| 2 | Aziz | 78 | ||||||||||||||||||||||
| 3 | Dilnoza | 92 | ||||||||||||||||||||||
| 4 | Jasur | 55 | ||||||||||||||||||||||
| 5 | Malika | 67 | ||||||||||||||||||||||
| 6 | ||||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||
| 8 | ||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||
| 10 |
Лист1
Готово
−+100%
Test your knowledge
Do graded exercises on these topics in the “Practice” section and earn coins.
Go to exercises16 / 16