What you will build
Complete “Understand cell references” using the visible Item, Qty, Unit price, Line total sample so each action and the final state can be checked against the source data.
Learning objectives
Open the practice workbook
The workbook uses a small fictional dataset. TSV copies data only; the XLSX file is the independent downloadable fallback.
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Sample data
| Item | Qty | Unit price | Line total |
|---|---|---|---|
| Pen | 3 | 5 | |
| Notebook | 2 | 20 | |
| Folder | 1 | 12 |
Blank cells are reserved for formulas or lesson outcomes; do not type guessed answers into them.
Hands-on practice
Step 1: Open the practice workbook, activate the correct tab, and confirm the table starts at A1.
Step 2: Perform the main action on the exact range without overwriting source columns.
Step 3: Verify the final state, change one value as a test, then restore the original sample.
=B2*C2Enter the formula in D2; then fill down through row 4.
Checkpoint
| Item | Qty | Unit price | Line total |
|---|---|---|---|
| Pen | 3 | 5 | 15 |
| Notebook | 2 | 20 | 40 |
| Folder | 1 | 12 | 12 |
For formula lessons, result cells must be calculated rather than typed manually.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Item, Qty, Unit price, Line total source fields.
Independent practice
Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Key takeaways
- ✓Complete “Understand cell references” using the visible Item, Qty, Unit price, Line total sample so each action and the final state can be checked against the source data.
- ✓Open the practice workbook, activate the correct tab, and confirm the table starts at A1.
- ✓Perform the main action on the exact range without overwriting source columns.
- ✓If the result differs, repeat “Open the practice workbook, activate the correct tab, and confirm the table starts at A1.” and then “Perform the main action on the exact range without overwriting source columns.”. Verify the working table still uses Item, Qty, Unit price, Line total before changing source values.
- ✓Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Navigate the Sheets toolbar.