Google Sheets Collaboration and Sharing Settings Questions and Answers

Question 1

A project manager wants to share a project plan with a client. The client needs to see the latest updates and add notes, but should not be able to change any project deadlines or task assignments. What is the most appropriate sharing permission to grant the client?

Accepted Answer

Commenter

Answer

The 'Commenter' role is ideal for this scenario. It allows the user to view all the data in the sheet and add comments to cells, but prevents them from directly editing or changing any of the cell content.

Question 2

When sharing a Google Sheet via a link, what is the key difference between the 'Anyone with the link' and 'Public on the web' settings?

Accepted Answer

'Public on the web' allows the sheet to be indexed by search engines, while 'Anyone with the link' does not.

Answer

The primary distinction is discoverability. 'Public on the web' makes the document searchable and findable through search engines like Google. 'Anyone with the link' keeps the document unlisted; a user must have the direct URL to access it.

Question 3

A team lead is sharing a sensitive financial report. They want to prevent collaborators with 'Viewer' and 'Commenter' access from making copies, printing, or downloading the file. Which of the following settings must be configured?

Accepted Answer

In the advanced sharing settings, check the box to 'Disable options to download, print, and copy for commenters and viewers'.

Answer

This specific setting, found by clicking the gear icon in the sharing dialog, is designed for Information Rights Management (IRM) to prevent data exfiltration by users who do not have edit rights.

Question 4

You have a master dashboard sheet that pulls data from several other sheets. You want to give a junior analyst 'Editor' access to the entire workbook so they can update the source data sheets, but you must prevent them from accidentally changing the formulas on the master dashboard sheet. What is the best course of action?

Accepted Answer

Use the 'Protect sheet' feature on the master dashboard and only allow yourself to edit that specific sheet.

Answer

The 'Protect sheet' feature allows for granular control within a workbook. You can grant 'Editor' access to the entire file but then lock down a specific sheet (or range) so that only designated users (like yourself) can make changes to it.

Question 5

A user reverts a Google Sheet to a version from two days ago using the Version History feature. What happens to the changes that were made between that older version and the current time?

Accepted Answer

They are not deleted; the state of the sheet before the restore is preserved within the Version History and can be reverted to again.

Answer

Google Sheets' Version History is non-destructive. When you restore an older version, the more recent state (the one just before you clicked restore) is still saved in the history. You can go back into the Version History and restore that more recent version if needed.

Google Sheets Test Practice Test

Google Sheets Test Practice Test

Google Sheets Collaboration and Sharing Settings Questions and Answers