What you will build
Complete “Undo restore and version history” using the visible Task, 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: Confirm A1:B4 matches the source table, then change B3 from Working to Blocked as a temporary test.
Step 2: Open File > Version history and point to See version history.
Step 3: Open See version history and verify the current version shows Dataset | Blocked while an earlier version is listed in the right sidebar.
Step 4: Use the back arrow to return to the sheet, then press Ctrl+Z once to Undo the temporary edit.
Step 5: Verify B3 is Working again and A1:B4 matches the checkpoint.
Checkpoint
| Task | Status |
|---|---|
| Brief | Done |
| Dataset | Working |
| QA | Planned |
Checkpoint for “Undo restore and version history”: the Task, Status 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, 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
- ✓Make one reversible test edit and remember the original value.
- ✓Use File > Version history > See version history.
- ✓Compare the current version with the earlier version in the sidebar.
- ✓Return to the sheet before using Undo.
- ✓Finish only after B3 is Working again.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Create named ranges.