Google Sheets Test Google Sheets Collaboration and Sharing Settings 2 — Questions and Answers
Question 1: Which permission level allows a collaborator to make changes to cell values but NOT change the sharing settings of the spreadsheet?
- Editor (Correct answer)
- Owner
- Viewer
- Commenter
Correct answer: Editor
Editors can modify content but only the Owner can change sharing settings by default.
Question 2: What does the 'Anyone with the link' sharing option mean?
- Anyone who has the URL can access it without an invitation (Correct answer)
- Only people in your organization can access it
- Only invited email addresses can access it
- Only the owner can access it
Correct answer: Anyone who has the URL can access it without an invitation
'Anyone with the link' grants access to any person who obtains the URL, with no sign-in required.
Question 3: A Commenter opens a shared sheet. What can they do?
- Add comments and suggestions but not edit cell values (Correct answer)
- Edit cells and add comments
- Change sharing permissions
- Delete the spreadsheet
Correct answer: Add comments and suggestions but not edit cell values
Commenters may leave comments and suggestions but cannot alter the actual data.
Question 4: How can an Owner prevent Editors from re-sharing a spreadsheet with others?
- Disable 'Editors can change permissions and share' in sharing settings (Correct answer)
- Set the sheet to Viewer only
- Delete all Editors
- Protect every sheet range
Correct answer: Disable 'Editors can change permissions and share' in sharing settings
The Owner can restrict re-sharing via the advanced sharing setting that stops editors from changing permissions.
Question 5: What happens when you transfer ownership of a spreadsheet to another person?
- The new person becomes Owner and the original owner becomes an Editor (Correct answer)
- The original owner loses all access
- The file is duplicated
- The new person becomes a Viewer
Correct answer: The new person becomes Owner and the original owner becomes an Editor
After a transfer, the previous owner is downgraded to Editor while the recipient gains ownership.
Question 6: Which feature lets you restrict editing of specific cells while still allowing collaborators to edit the rest of the sheet?
- Protected ranges (Correct answer)
- Named ranges
- Filter views
- Data validation
Correct answer: Protected ranges
Protected ranges let the owner limit who can edit particular cells or sheets.
Question 7: What does a Viewer see when they open a shared spreadsheet?
- Read-only content with no ability to edit or comment (Correct answer)
- Full editing tools
- The comment sidebar with the ability to reply
- Sharing settings
Correct answer: Read-only content with no ability to edit or comment
Viewers can only read the spreadsheet and cannot make any changes or comments.
Google Sheets Test Google Sheets Collaboration and Sharing Settings 2
Which permission level allows a collaborator to make changes to cell values but NOT change the sharing settings of the spreadsheet?