Excel Vocabulary (Essential English Terms) : Lesson 25 — ComputerSeekhoAurJobPao
Lesson 25: Excel Vocabulary (Important English Terms)
What You Will Learn
Excel is often called a "Smart Register." But this smart register has its own language — its own vocabulary. If you understand these 10–12 essential words, Excel will become much easier for you.
1. Data
Data means Information. Everything you type in Excel — whether it is someone's name, a phone number, or an expense record — is called Data.
2. Entry
Typing something into a cell in Excel is called making an Entry.
3. Cell
Every small box in Excel where you type data is called a Cell.
- • Simply put: Cell = one box in Excel
- • A cell is identified by a Column letter and a Row number
Example: In A1 — A is the column name and 1 is the row number.
4. Column
A vertical line (running top to bottom) is called a Column. Columns are identified by letters in Excel.
Example: A, B, C, D
5. Row
A horizontal line (running left to right) is called a Row. Rows are identified by numbers in Excel.
Example: 1, 2, 3, 4
6. Range
A group of more than one cell is called a Range. When you select multiple boxes at once, that selection is called a Range.
Example: A1:A10 — the entire group from Cell A1 to A10.
7. Reference
The address of a cell is called a Cell Reference.
Example: A1, B2, C3
8. Formula
A Formula is used in Excel to perform calculations — addition, subtraction, multiplication, division. Every formula in Excel starts with an = (equal sign).
Example: =10+20 — Excel will automatically show the result as 30.
9. Sheet
One page inside an Excel file is called a Sheet. You can have many sheets inside a single file.
Example: January sheet, February sheet, and so on.
10. Workbook
The entire Excel file is called a Workbook.
📄 Sheet = One page inside that file
11–16. More Important Terms
11. Format — Making your data look good — adding colours, changing font size, or styling the text — is called Formatting.
12. Header / Heading — The first line of a table that tells you what is written below. For example: Name, Date, Salary.
13. Sort — Arranging data in a sequence — such as A to Z or 1 to 100.
14. Filter — Finding specific information from a large dataset — for example, showing only Delhi-based employees from a list of 1,000 people.
15. Alignment — Setting the position of text inside a cell: Left, Right, or Centre.
16. Error — A mistake in a formula or data. For example: #VALUE! or #REF!
Office Context Summary
| English Term | Meaning in an Office |
|---|---|
| Input | Entering something into the computer (typing) |
| Output | The result shown on screen or printed |
| Save | Keeping your work safe |
| Total / Sum | Adding everything together |
What You Learned in This Lesson:
- The meaning of 16 essential Excel vocabulary words
- The difference between Cell, Row and Column
- What Range, Reference and Formula mean
- The difference between a Workbook and a Sheet
- Practical use of these terms in an office context
Comments
Post a Comment