Google Sheets Test Google Sheets Collaboration and Sharing Settings 4

Question 1

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

Accepted Answer

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

Answer

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

Question 2

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

Accepted Answer

Share files with external (non-organization) email addresses

Answer

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

Question 3

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

Accepted Answer

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

Answer

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

Question 4

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

Accepted Answer

Restricted, adding only the two accountants' emails

Answer

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

Question 5

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?

Accepted Answer

They can no longer open the file unless individually added

Answer

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

Google Sheets Test Practice Test