What you will build
Complete “Use smart chips in a spreadsheet” using the visible Task, Owner, Due 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: Confirm the source table is A1:C4, then select the empty cell D2 so the smart-chip test does not overwrite Task, Owner, or Due.
Step 2: Choose Insert > Smart chips > Rating.
Step 3: Verify a five-star rating chip appears in D2, then click the chip and set a test rating.
Step 4: Clear D2 after the test and verify A1:C4 still matches the checkpoint exactly.
Checkpoint
| Task | Owner | Due |
|---|---|---|
| Confirm brief | Linh | 2026-09-28 |
| Prepare dataset | Minh | 2026-09-30 |
| Review output | An | 2026-10-02 |
Checkpoint for “Use smart chips in a spreadsheet”: the Task, Owner, Due columns and sample records must still match this table 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, Due 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
- ✓Use an empty test cell outside the source table.
- ✓Open Insert > Smart chips > Rating.
- ✓Verify the rating chip appears in D2.
- ✓Change the rating once to test the chip.
- ✓Clear D2 and confirm the source table is unchanged.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Find and replace spreadsheet values.