What you will build
Complete “Use keyboard shortcuts efficiently” 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:C2, the Brief | Linh | Done row.
Step 2: Press Ctrl+C, select A5, then press Ctrl+V. Verify the complete row is copied to A5:C5. On macOS, use Command+C and Command+V.
Step 3: Press Ctrl+Z to Undo and verify row 5 becomes blank again. On macOS, use Command+Z.
Step 4: Press Ctrl+Y to Redo and verify the copied row returns at A5:C5.
Step 5: Press Ctrl+Z once more and confirm the original A1:C4 table is restored before finishing.
Checkpoint
| Task | Owner | Status |
|---|---|---|
| Brief | Linh | Done |
| Dataset | Minh | Working |
| QA | An | Planned |
Checkpoint for “Use keyboard shortcuts efficiently”: 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 range before using a shortcut.
- ✓Use Ctrl+C and Ctrl+V to copy and paste; use Command on macOS.
- ✓Use Ctrl+Z to Undo.
- ✓Use Ctrl+Y to Redo on Windows/ChromeOS.
- ✓Finish by restoring the original A1:C4 table.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Undo restore and version history.