Workbook Layout, Cells & Navigation
Understand the Ribbon, Name Box, Formula Bar, worksheet tabs, and how every cell gets its column-letter + row-number address.
Key takeaways while you watch
- Every cell address starts with its Column letter followed by its Row number (for example, C4 sits at column C, row 4).
- The Formula Bar displays what is truly stored inside a cell (the raw formula or unformatted value), even when the cell displays a formatted result.
- Press Ctrl + Arrow keys to jump to the edge of a data block instead of scrolling manually.
Cell Coordinate Drill
Look at the quarterly inventory snapshot below. Which exact cell address holds the Units Sold for Desk Lamp?
| A (Item) | B (Category) | C (Units Sold) | D (Unit Price) | |
|---|---|---|---|---|
| 1 | Item | Category | Units Sold | Unit Price |
| 2 | USB-C Hub | Hardware | 48 | $29 |
| 3 | Desk Lamp | Office | 65 | $42 |
| 4 | Notebook Pack | Supplies | 120 | $12 |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.