Goal
You’ll be able to navigate Excel’s basic interface confidently, and understand the fundamental grid structure that everything else in this course builds on.
Learn
An Excel file is called a workbook. A workbook contains one or more worksheets (the tabs at the bottom), and each worksheet is a grid of cells, organized into columns (labeled with letters: A, B, C…) and rows (labeled with numbers: 1, 2, 3…).
Every cell has a unique address, called a cell reference, combining its column letter and row number: A1 is the cell in column A, row 1. C5 is column C, row 5. This addressing system is the single most important concept in all of Excel — nearly everything else (formulas, formatting, charts) depends on referring to cells by their address.
The Ribbon at the top organizes commands into tabs (Home, Insert, Formulas, Data, etc.), each containing related groups of buttons. The Name Box (top-left, above column A) shows which cell is currently selected, and can also be typed into to jump directly to a specific cell. The Formula Bar (next to the Name Box) shows the actual content of the currently selected cell — including the underlying formula if the cell displays a calculated result, not just the visible number.
You can move between cells using arrow keys, or by clicking directly. Pressing Ctrl + an arrow key jumps to the edge of a continuous block of data — a genuinely useful shortcut once your spreadsheets grow larger than what fits on one screen.
Decision Task
You want to see the actual formula behind a cell that’s currently displaying the number 150, not just the displayed result. Before reading on: where specifically would you look to see that underlying formula?
Show Answer
The Formula Bar — clicking on that cell shows its actual content (including any formula) in the Formula Bar at the top, even though the cell itself visually displays only the calculated result (150). This distinction — displayed value versus underlying formula — is genuinely important and comes up constantly once you start using real formulas.
Common Mistake
Confusing a cell’s displayed value with its actual content. A cell showing “150” might contain the literal number 150 typed directly, or it might contain a formula like =100+50 that calculates to 150 — these look identical on the worksheet itself, but behave completely differently if the underlying numbers ever change. Always check the Formula Bar when you need to know which one you’re actually looking at.
Practice Questions
1. What is the cell reference for the cell in column D, row 8?
Show Answer
D8
2. What is a workbook, and how does it relate to a worksheet?
Show Answer
A workbook is the entire Excel file; a worksheet is one individual tab/grid within that file. A single workbook can contain multiple worksheets.
3. Where would you look to see which cell is currently selected, by its reference?
Show Answer
The Name Box, in the top-left corner above column A.
4. True or False: a cell displaying a number always means that number was typed in directly, never calculated by a formula.
Show Answer
False — a cell can display a calculated result from a formula, which looks identical to a directly-typed number unless you check the Formula Bar.
5. What does pressing Ctrl plus an arrow key do?
Show Answer
Jumps to the edge of a continuous block of data in that direction, a useful navigation shortcut for larger spreadsheets.
Try It Yourself
Without looking back, explain in your own words the difference between a workbook, a worksheet, and a cell.
Show Answer
A workbook is the entire Excel file; a worksheet is one individual tab/page within that file; a cell is one individual box within a worksheet’s grid, identified by its column-letter-plus-row-number address, like B4.
Quick Check
1. What is an Excel file called?
Show Answer
A workbook.
2. What are the tabs at the bottom of an Excel window called?
Show Answer
Worksheets.
3. How is a cell reference constructed?
Show Answer
Column letter followed by row number, like A1 or C5.
4. What does the Formula Bar show?
Show Answer
The actual content of the currently selected cell, including any underlying formula.
5. What does the Name Box show?
Show Answer
Which cell is currently selected, by its reference — and can also be used to jump directly to a specific cell.