The Excel window
The Excel window has a few main parts. Knowing them helps you find commands fast.
The ribbon
Tabs across the top: Home, Insert, Formulas and more. Each tab holds grouped buttons: font, alignment, number format, filter…
Name box and formula bar
The small box on the left shows the selected cell’s address (e.g. C3). The long bar next to it is the formula bar: if a cell holds a formula, you see the formula here, not the result.
Grid, sheets and status bar
The grid of cells sits in the middle, sheet tabs below it, and the status bar at the very bottom: select several numbers and it shows their sum and average.
Tips
- The formula bar is the best place to check a formula.
- If the ribbon gets in the way, hide it with Ctrl+F1.
Try it in the simulator
Select C3 and look at the address in the name box. Then drag over C2:C5 and look at the status bar.
Книга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 | Product | Qty | Price | Total | ||||||||||||||||||||
| 2 | Bread | 3 | 4000 | |||||||||||||||||||||
| 3 | Milk | 2 | 12000 | |||||||||||||||||||||
| 4 | Eggs | 10 | 1500 | |||||||||||||||||||||
| 5 | Tea | 1 | 25000 | |||||||||||||||||||||
| 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 exercises