Theory
Meera's shop runs on one screen
Meera runs a kirana store in Rajkot. Every evening she used to tally the day's sales in a paper register, adding columns by hand, often at midnight.
Her nephew set up one Excel file, and now the totals appear the instant she types a number.
That file is where this whole subject begins. Before Meera can compute anything, she needs the vocabulary of the grid she is looking at: workbook, worksheet, cell, address. Get these four words exact and the rest of Excel unlocks.
Theory
A notebook with tabbed pages
Think of a spiral notebook with coloured tabs. The whole notebook is the workbook (Meera's one file). Each tabbed page is a worksheet (one for January, one for February). Every page is printed with a grid of boxes, and each box is a cell. You do not buy a new notebook per month; you flip to a new tab. One workbook, many worksheets.
Theory
The four words, exactly
- Workbook: the entire Excel file (
meera-sales.xlsx). - Worksheet (sheet): one tabbed page of grid inside it; switch pages using the tabs at the bottom.
- Columns run vertical, labelled by letters (A, B, C ... then AA, AB).
- Rows run horizontal, labelled by numbers (1, 2, 3 ...).
- A cell is the box where one column meets one row, the place you type.
Theory
Every box has an address
A city has millions of houses, but "House 7, MG Road" points to exactly one. A worksheet is the same: its cell address is the column letter then the row number.
A1 is the top-left corner. In Meera's sheet, B7 means column B (price), row 7, the price of her seventh item.
That address shows in the Name Box (top-left). The order never flips: it is always column, then row, B7, never 7B.
Theory
The formula bar shows the truth
Click a cell and look at the formula bar (the long strip above the grid). The cell might display 450, but the formula bar could reveal =B7*C7. The cell shows the result; the formula bar shows the real content. This gap, display versus true content, is the single most useful habit in Excel: when a number looks wrong, read the formula bar, not the cell.
Quiz
In Meera's sheet, the price of the 7th item sits in column B, row 7. What is its cell address?
- B7
- 7B
- R7C2
- B:7
Show the answer
B7
A cell address is always column letter first, then row number: B7. Writing 7B reverses the convention and Excel rejects it. (R7C2 is a rarely-used alternate style Excel can switch to, but the standard answer expected in exams is B7.) Same row-then-column care you practised with BCA102 matrices, just spelled with a letter.
Think first
Display vs truth
Meera's cell D7 shows 450 on the grid. She clicks it and the formula bar reads =B7*C7. Take five seconds: what is actually stored in D7, a number or a formula? And what would happen to D7 if she changed B7?
Show the answer
D7 stores a formula (=B7*C7), not the number 450. The 450 is only what the formula computed right now. Change B7 (the price) and D7 recalculates itself instantly. This is the entire power of a spreadsheet over a paper register: the answers are live, wired to their inputs, not frozen ink.
Watch out
Where marks leak
Writing the address as row-then-column (7B): always column letter first. Confusing workbook and worksheet: the workbook is the whole file; a worksheet is one tab inside it. And do not say a cell "contains 450" when it contains =B7*C7, the display is the result, the cell holds the formula. Exams love a one-mark "name the parts of the Excel window" diagram; label the Name Box and formula bar.
Formula
Where this is heading
Meera's grid is really a data table: column A is item names, B is prices, C is quantities, one row per product. That is exactly the shape a database table will take in Unit 3, and the address B7 is the ancestor of a database's "this column, this record". You are learning spreadsheets and quietly meeting databases at the same time.
Summary
Key takeaways
- Workbook = the whole Excel file; worksheet = one tabbed page of grid inside it.
- Columns are vertical (letters A, B, C); rows are horizontal (numbers 1, 2, 3).
- A cell is a column-row box; its address is column letter THEN row number (B7).
- The Name Box shows the address; the formula bar shows the cell's true content.
- A cell displays a result but may store a formula, so answers stay live.
- Memory hook: notebook (workbook), tabbed page (worksheet), box (cell), column-then-row.