Google Sheets Test Google Sheets Data Validation and Protection 3 — Questions and Answers
Question 1: Which menu is used to protect a sheet or range in Google Sheets?
- Data > Protect sheets and ranges (Correct answer)
- Format > Protection
- File > Protect
- View > Protect
Correct answer: Data > Protect sheets and ranges
Protection is configured under Data > Protect sheets and ranges.
Question 2: When you protect a range, what is the effect on users without edit permission?
- They cannot view the range
- They see a warning or are blocked from editing it (Correct answer)
- The range is hidden entirely
- They are removed from the sheet
Correct answer: They see a warning or are blocked from editing it
Protected ranges either warn users or prevent them from editing depending on settings.
Question 3: Which protection option only warns a user before they edit rather than blocking them?
- Restrict who can edit this range
- Show a warning when editing this range (Correct answer)
- Hide sheet
- Lock workbook
Correct answer: Show a warning when editing this range
The 'Show a warning' setting allows edits but prompts a confirmation first.
Question 4: Can you protect an entire sheet while leaving certain cells editable?
- No, protection is all-or-nothing
- Yes, by adding exceptions for specific cells (Correct answer)
- Only in Excel
- Only with a script
Correct answer: Yes, by adding exceptions for specific cells
You can protect a whole sheet and specify 'Except certain cells' to keep some editable.
Question 5: Who can always edit a protected range regardless of settings?
- Anyone with the link
- The file owner and editors granted permission (Correct answer)
- View-only users
- Nobody
Correct answer: The file owner and editors granted permission
The owner and users explicitly granted edit permission can modify protected ranges.
Question 6: What does protecting a range NOT prevent?
- Editing cell contents
- Viewing or copying the data (Correct answer)
- Deleting values
- Changing formulas
Correct answer: Viewing or copying the data
Range protection restricts editing but does not stop users from viewing or copying the data.
Question 7: Where do you set permissions after clicking 'Set permissions' on a protected range?
- A dialog to restrict who can edit (Correct answer)
- The print settings
- The chart editor
- The named ranges panel
Correct answer: A dialog to restrict who can edit
'Set permissions' opens a dialog to choose warning mode or restrict specific editors.
Google Sheets Test Google Sheets Data Validation and Protection 3
Which menu is used to protect a sheet or range in Google Sheets?