Protected sheets and ranges in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to protect the entire sheet named "Data".

Google Sheets

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data");
sheet.[1]();

Drag options to blanks, or click blank then click option'

AsetProtection

BprotectSheet

Cprotect

DprotectRange

Attempts:

3 left

💡 Hint

Common Mistakes

Using methods that don't exist like protectSheet or protectRange.

Confusing protection methods with range selection.

The method protect() is used to protect the entire sheet in Google Sheets scripts.

2fill in blank

medium

Complete the code to protect a specific range A1:B10 on the active sheet.

Google Sheets

var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange("A1:B10");
var protection = range.[1]();

Drag options to blanks, or click blank then click option'

Aprotect

BsetProtection

Clock

DprotectRange

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-existent methods like setProtection or lock.

Trying to protect the sheet instead of the range.

The protect() method is used on a range object to protect that range.

3fill in blank

hard

Fix the error in the code to remove editors from a protected range.

Google Sheets

var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange("C1:C5");
var protection = range.protect();
protection.[1]([]);

Drag options to blanks, or click blank then click option'

AdeleteEditors

BremoveEditors

CclearEditors

DsetEditors

Attempts:

3 left

💡 Hint

Common Mistakes

Using removeEditors which does not exist.

Trying to clear or delete editors with wrong method names.

The method setEditors([]) sets the editors list to empty, effectively removing all editors.

4fill in blank

hard

Fill both blanks to protect a range and set a description.

Google Sheets

var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange("D1:D10");
var protection = range.[1]();
protection.[2]("Confidential Data");

Drag options to blanks, or click blank then click option'

Aprotect

BsetDescription

CsetName

Dlock

Attempts:

3 left

💡 Hint

Common Mistakes

Using setName instead of setDescription.

Trying to lock the range with a non-existent method.

Use protect() to protect the range and setDescription() to add a description.

5fill in blank

hard

Fill all three blanks to protect a sheet, set a description, and remove all editors.

Google Sheets

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Summary");
var protection = sheet.[1]();
protection.[2]("Sheet locked for editing");
protection.[3]([]);

Drag options to blanks, or click blank then click option'

Aprotect

BsetDescription

CsetEditors

Dlock

Attempts:

3 left

💡 Hint

Common Mistakes

Using lock instead of protect.

Trying to remove editors with a non-existent method.

Protect the sheet with protect(), add description with setDescription(), and remove editors by setting an empty list with setEditors([]).