What you will build

Complete “Check file ownership before sharing” using the visible File, Owner, Share plan sample so each action and the final state can be checked against the source data.

Learning objectives

Open the practice workbook

HANDS-ON PRACTICE

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.

Make a Google Sheets copy (access required) ↗View original

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.

The _result workbook shows the clean File, Owner, Share plan sample before opening Share.

Hands-on practice

Step 1: Open Share and identify the actual owner before changing permissions.

The current-audit Share dialog shows the account marked Owner before any permission change.

Step 2: Confirm General access is set to Restricted before changing any sharing permission.

The current-audit Share dialog shows General access set to Restricted, confirming no sharing setting was changed.

Step 3: In Share, confirm the owner is marked Owner and leave General access set to Restricted unless the exercise specifies a real recipient.

Checkpoint

FileOwnerShare plan
BudgetLinhViewer
TrackerMinhCommenter

Checkpoint for “Check file ownership before sharing”: the File, Owner, Share plan 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 File, Owner, Share plan 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

  • ✓Complete “Check file ownership before sharing” using the visible File, Owner, Share plan sample so each action and the final state can be checked against the source data.
  • ✓Open Share and identify the actual owner before changing permissions.
  • ✓Confirm General access is set to Restricted before changing any sharing permission.
  • ✓In Share, confirm the owner is marked Owner and leave General access set to Restricted unless the exercise specifies a real recipient.
  • ✓Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. What is the correct first action in “Check file ownership before sharing”?
2. Which follow-up action belongs to “Check file ownership before sharing”?
3. What should you verify before “Check file ownership before sharing” is complete?
4. Which correction is appropriate if “Check file ownership before sharing” behaves unexpectedly?

Next lesson

Continue in recommended learning order with Use protected sheets for templates.