Google Sheets Test Google Sheets Collaboration and Sharing Settings 2

Question 1

Which permission level allows a collaborator to make changes to cell values but NOT change the sharing settings of the spreadsheet?

Accepted Answer

Editor

Answer

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?

Accepted Answer

Anyone who has the URL can access it without an invitation

Answer

'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?

Accepted Answer

Add comments and suggestions but not edit cell values

Answer

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?

Accepted Answer

Disable 'Editors can change permissions and share' in sharing settings

Answer

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?

Accepted Answer

The new person becomes Owner and the original owner becomes an Editor

Answer

After a transfer, the previous owner is downgraded to Editor while the recipient gains ownership.

Google Sheets Test Practice Test