What you will build
Complete “Rename duplicate and color sheet tabs” using the visible Task, Owner, Status, 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: Right-click the Example sheet tab, choose Rename, and rename it to Current.
Step 2: Right-click Current, choose Duplicate, then rename the duplicated tab to Archive.
Step 3: Right-click Archive, choose Change color, and select a green tab color.
Step 4: Verify Current and Archive are adjacent, Archive shows the green tab color, and the source table still matches the checkpoint.
Checkpoint
| Task | Owner | Status | Due |
|---|---|---|---|
| Confirm brief | Linh | Done | 2026-09-28 |
| Prepare dataset | Minh | Working | 2026-09-30 |
| Review output | An | Planned | 2026-10-02 |
For formula lessons, result cells must be calculated rather than typed manually.
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, 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
- ✓Rename Example to Current from the sheet-tab menu.
- ✓Duplicate Current and rename the duplicate Archive.
- ✓Use Change color on Archive and choose a light green color.
- ✓Verify Current and Archive are adjacent and the source table is unchanged.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Move and copy rows and columns.