What you will build
Complete “Add notes and comments to cells” using the visible Task, Owner, Status 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 A2, the Brief cell, and verify the formula bar still shows Brief before adding any annotation.
Step 2: Choose Insert > Note, type “Static reference: confirm the brief before editing.”, then click outside the note so the value Brief remains unchanged.
Step 3: Select A2 again and choose Insert > Comment. Type “Please confirm the brief before editing.” in the comment box; use a comment when discussion or @mentions are needed.
Step 4: Compare the two annotation types: the note stores static reference text on A2, while the comment opens a discussion box; neither should replace the cell value Brief.
Checkpoint
| Task | Owner | Status |
|---|---|---|
| Brief | Linh | Done |
| Dataset | Minh | Working |
| QA | An | Planned |
Checkpoint for “Add notes and comments to cells”: keep the Task, Owner, Status source records intact after the lesson action.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Task, Owner, Status 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
- ✓Select the exact target cell before adding an annotation.
- ✓Use Insert > Note for static reference text.
- ✓Use Insert > Comment for discussion or @mentions.
- ✓Verify the original cell value remains unchanged.
- ✓Choose the annotation type based on whether collaboration is required.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Resolve comments and assign tasks.