Google Sheets Collaboration and Sharing Settings Questions and Answers 1 — 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?
- Viewer
- Editor
- Commenter (Correct answer)
- Owner
Correct answer: Commenter
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?
- 'Public on the web' allows the sheet to be indexed by search engines, while 'Anyone with the link' does not. (Correct answer)
- 'Anyone with the link' requires the user to have a Google account, while 'Public on the web' does not.
- 'Public on the web' is only available for Google Workspace accounts, while 'Anyone with the link' is for personal accounts.
- There is no functional difference; they are two names for the same setting.
Correct answer: 'Public on the web' allows the sheet to be indexed by search engines, while 'Anyone with the link' does not.
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?
- Set the general access link sharing to 'Restricted'.
- Protect the entire sheet and grant 'View only' permission to those users.
- Use a data validation rule on all cells to 'Reject input'.
- In the advanced sharing settings, check the box to 'Disable options to download, print, and copy for commenters and viewers'. (Correct answer)
Correct answer: In the advanced sharing settings, check the box to 'Disable options to download, print, and copy for commenters and viewers'.
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?
- Hide the master dashboard sheet so the analyst cannot see it.
- Use the 'Protect sheet' feature on the master dashboard and only allow yourself to edit that specific sheet. (Correct answer)
- Share the master dashboard sheet as 'View only' and the other sheets as 'Editor'.
- Add a prominent comment on the dashboard instructing the analyst not to edit it.
Correct answer: Use the 'Protect sheet' feature on the master dashboard and only allow yourself to edit that specific sheet.
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?
- They are permanently deleted and cannot be recovered.
- They are archived into a new, separate Google Sheet file.
- They are not deleted; the state of the sheet before the restore is preserved within the Version History and can be reverted to again. (Correct answer)
- They are emailed to the document owner as a change log before being discarded.
Correct 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.
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.
Question 6: Which of the following best describes what happens when a user is @mentioned in a comment within a Google Sheet?
- A notification is sent only if the user has 'Editor' access to the sheet.
- An email is sent only if the user's notification settings for that specific sheet are set to 'All comments'.
- A notification is sent only if the comment is left on a protected range that the user owns.
- By default, the user will receive a direct email notification, regardless of their general notification settings for the sheet. (Correct answer)
Correct answer: By default, the user will receive a direct email notification, regardless of their general notification settings for the sheet.
The @mention feature is specifically designed to get a particular person's attention. By default, it overrides the sheet's general notification settings ('All comments' or 'None') and sends a direct email to the person who was mentioned. Users can choose to be notified only for comments that mention them ('Comments for you').
Google Sheets Collaboration and Sharing Settings Questions and Answers 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?