Google Sheets Test Google Sheets Collaboration and Sharing Settings 3 — Questions and Answers
Question 1: You want collaborators to work together on the same sheet at the same time and see each other's cursors. What is this called?
- Real-time collaboration (Correct answer)
- Version pinning
- Offline mode
- Batch editing
Correct answer: Real-time collaboration
Google Sheets supports real-time collaboration where multiple users edit simultaneously with visible cursors.
Question 2: How can you leave a comment directed at a specific collaborator so they receive an email notification?
- Type '+' or '@' followed by their email in the comment (Correct answer)
- Bold their name in a cell
- Change the cell color
- Add them as a Viewer
Correct answer: Type '+' or '@' followed by their email in the comment
Using '+' or '@' with an email in a comment assigns it to that person and notifies them.
Question 3: What does 'Suggesting' behavior look like in Google Sheets compared to Google Docs?
- Sheets has no full Suggesting mode; suggestions are made via comments (Correct answer)
- Sheets shows tracked strike-through edits like Docs
- Sheets locks the file during suggestions
- Sheets emails every change automatically
Correct answer: Sheets has no full Suggesting mode; suggestions are made via comments
Unlike Docs, Sheets does not offer a Suggesting edit mode—collaborators use comments instead.
Question 4: Where can you view a complete history of who changed what in a spreadsheet?
- File > Version history (Correct answer)
- Data > Sort range
- Insert > Comment
- Tools > Script editor
Correct answer: File > Version history
Version history under the File menu shows all edits and the collaborators who made them.
Question 5: A collaborator with edit access accidentally deleted a column. How can the owner recover it?
- Restore a previous version from Version history (Correct answer)
- Re-share the file
- Change the collaborator to Viewer
- Delete the spreadsheet
Correct answer: Restore a previous version from Version history
Version history allows restoring an earlier state before the column was deleted.
Question 6: What is the effect of setting a link-share to 'Restricted'?
- Only people explicitly added can open the file (Correct answer)
- Anyone with the link can edit
- The file becomes public on the web
- Everyone in the domain can view
Correct answer: Only people explicitly added can open the file
'Restricted' limits access to only the specific people who have been granted permission.
Question 7: How do you notify newly added collaborators by email when sharing?
- Check the 'Notify people' box in the Share dialog (Correct answer)
- Add them as Owners
- Publish to the web
- Insert a comment mentioning them
Correct answer: Check the 'Notify people' box in the Share dialog
The Share dialog includes a 'Notify people' checkbox that emails an invitation to added users.
Google Sheets Test Google Sheets Collaboration and Sharing Settings 3
You want collaborators to work together on the same sheet at the same time and see each other's cursors.
What is this called?