Google Sheets Collaboration and Sharing Settings Flashcards

What does 'Publish to the web' do for a Google Sheet?

Answer: Creates a public web page or embeddable link of the sheet's content

Publishing to the web makes a read-only version viewable via a public URL or embed, separate from normal sharing.

An organization admin sets a domain restriction. What might a user be unable to do?

Answer: Share files with external (non-organization) email addresses

Domain restrictions can block sharing files outside the organization for security.

How can you set an expiration date on a collaborator's access to a spreadsheet?

Answer: Use 'Add expiration' in the advanced sharing options (Workspace)

Google Workspace lets owners add an expiration date to temporary access for Editors, Commenters, or Viewers.

What is the safest sharing setting for a sheet containing sensitive financial data shared with two accountants?

Answer: Restricted, adding only the two accountants' emails

Restricting access to named individuals ensures only intended people can open sensitive data.

If you share a sheet 'Anyone with the link - Viewer' and later change it to 'Restricted', what happens to people who had the old link?

Answer: They can no longer open the file unless individually added

Switching to Restricted revokes access for anyone not explicitly listed, even if they saved the link.

Which action lets you see a list of everyone who currently has access to a spreadsheet?

Answer: Open the Share dialog to view all people and their roles

The Share dialog lists every collaborator along with their permission level.

What does the 'Get link' copy option in the Share dialog do?

Answer: Copies the shareable URL to your clipboard based on current link settings

'Copy link' places the current shareable URL on your clipboard to paste and send.