Google Sheets Test Google Sheets Collaboration and Sharing Settings 3

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?

Accepted Answer

Real-time collaboration

Answer

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?

Accepted Answer

Type '+' or '@' followed by their email in the comment

Answer

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?

Accepted Answer

Sheets has no full Suggesting mode; suggestions are made via comments

Answer

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?

Accepted Answer

File > Version history

Answer

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?

Accepted Answer

Restore a previous version from Version history

Answer

Version history allows restoring an earlier state before the column was deleted.

Google Sheets Test Practice Test