What you will build
Complete “Use the formula bar and name box” using the visible Item, Qty, Price, Total sample so each action and the final state can be checked against the source data.
Learning objectives
Open the practice workbook
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.
Hands-on practice
Step 1: Select D2. Confirm the name box shows D2 and the formula bar is ready for input.
Step 2: Enter =B2*C2 in the formula bar and press Enter. D2 should calculate 15 from Qty 3 and Price 5.
Step 3: Fill the formula down through D4 and verify the totals are 15, 40, and 12. Change B2 to 4 once, confirm D2 becomes 20, then restore B2 to 3.
=B2*C2Enter the formula in D2; then fill down through row 4.
Checkpoint
| Item | Qty | Price | 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 cell or range named in the step, recheck the source data, and repeat the specified command; do not type the expected result manually.
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
- ✓Select D2. Confirm the name box shows D2 and the formula bar is ready for input.
- ✓Enter =B2*C2 in the formula bar and press Enter. D2 should calculate 15 from Qty 3 and Price 5.
- ✓Fill the formula down through D4 and verify the totals are 15, 40, and 12. Change B2 to 4 once, confirm D2 becomes 20, then restore B2 to 3.
- ✓After every test, restore the workbook to the checkpoint data.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Rename duplicate and color sheet tabs.