Google Sheets Collaboration and Sharing Settings Flashcards

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?

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.

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?

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.

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?

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.

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?

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.

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?

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.

Which of the following best describes what happens when a user is @mentioned in a comment within a Google Sheet?

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').