By the end of this lesson, you'll solve:
"Your teacher wants a neatly formatted mark sheet. Can you enter 30 students' data quickly and make it look professional with the right colours and borders?"
What is a Spreadsheet Cell?
Picture this: a spreadsheet is like a huge notebook with thousands of small boxes arranged in rows (numbered 1, 2, 3...) and columns (lettered A, B, C...). Each box is called a CELL. The address of a cell is its column letter + row number. So the cell in column A, row 1 is called A1, the one in column B row 2 is B2, and so on.
In Excel, columns are letters (A, B, C...) and rows are numbers (1, 2, 3...)
Key Points
- 1Columns go left-to-right: A, B, C, D... Z, AA, AB...
- 2Rows go top-to-bottom: 1, 2, 3, 4...
- 3Cell address = Column letter + Row number (e.g., C5, G10)
- 4The active cell shows its address in the Name Box (top-left corner)
- 5Click any cell to select it; the column letter and row number both highlight in the header
Pro Tip
Think of it like a seat number in a cinema hall: Row 5, Seat C = C5. Column letter always comes first!
Listen