What you will build
Complete “Create checkboxes for task lists” using the visible Task, Done 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 B2:B4 in the Done column; keep the B1 header out of the selection.
Step 2: Choose Insert > Checkbox. Verify B2 and B4 are unchecked while B3 is checked, matching FALSE, TRUE, FALSE from the sample.
Step 3: Click B2 once to check it and confirm the cell value changes from FALSE to TRUE.
Step 4: Click B2 again to restore FALSE and verify all three task rows match the checkpoint.
Checkpoint
| Task | Done |
|---|---|
| Confirm brief | false |
| Prepare dataset | true |
| Review output | false |
Checkpoint for “Create checkboxes for task lists”: the Task, Done 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, Done 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 only B2:B4, not the header.
- ✓Use Insert > Checkbox.
- ✓Unchecked is FALSE and checked is TRUE.
- ✓Toggle one checkbox to verify behavior.
- ✓Restore the original FALSE, TRUE, FALSE state.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Use smart chips in a spreadsheet.