Add-ons and extensions in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to open the Extensions menu in Google Sheets.

Google Sheets

Click on the [1] menu to find add-ons.

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

AFile

BView

CEdit

DExtensions

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'File' or 'Edit' instead of 'Extensions'.

The Extensions menu is where you find and manage add-ons in Google Sheets.

2fill in blank

medium

Complete the code to install an add-on from the Google Workspace Marketplace.

Google Sheets

Go to Extensions > [1] add-ons to browse and install.

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

AManage

BUpdate

CGet

DRemove

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Manage' or 'Remove' instead of 'Get'.

The 'Get add-ons' option opens the marketplace to install new add-ons.

3fill in blank

hard

Fix the error in the code to open the add-on's sidebar.

Google Sheets

After installing, click Extensions > [1] > Open sidebar.

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

AManage add-ons

BYour add-on name

CGet add-ons

DSettings

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Manage add-ons' or 'Get add-ons' instead of the add-on name.

You must select your specific add-on's name to open its sidebar.

4fill in blank

hard

Fill both blanks to write a formula that uses an add-on function named MYFUNC.

Google Sheets

= [1] (A1, [2])

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

AMYFUNC

BB2

CSUM

DA2

Attempts:

3 left

💡 Hint

Common Mistakes

Using built-in functions like SUM instead of the add-on function.

The formula calls the add-on function MYFUNC with cell A1 and A2 as arguments.

5fill in blank

hard

Fill all three blanks to write a script snippet that opens an add-on sidebar in Google Sheets.

Google Sheets

function showSidebar() {
  var ui = SpreadsheetApp.getUi();
  var html = HtmlService.createHtmlOutputFromFile('[1]')
    .setTitle('[2]')
    .setWidth([3]);
  ui.showSidebar(html);
}

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

ASidebar

BMy Add-on Sidebar

C300

DCode

ESettings

F400

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong file names or titles, or setting width too small or too large.

The script loads the HTML file named 'Sidebar', sets the sidebar title, and width 400 pixels.