Recommended
Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete 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'
Attempts:
3 left
💡 Hint
Common Mistakes
Choosing 'File' or 'Edit' instead of 'Extensions'.
✗ Incorrect
The Extensions menu is where you find and manage add-ons in Google Sheets.
2fill in blank
mediumComplete 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'
Attempts:
3 left
💡 Hint
Common Mistakes
Selecting 'Manage' or 'Remove' instead of 'Get'.
✗ Incorrect
The 'Get add-ons' option opens the marketplace to install new add-ons.
3fill in blank
hardFix 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'
Attempts:
3 left
💡 Hint
Common Mistakes
Choosing 'Manage add-ons' or 'Get add-ons' instead of the add-on name.
✗ Incorrect
You must select your specific add-on's name to open its sidebar.
4fill in blank
hardFill 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'
Attempts:
3 left
💡 Hint
Common Mistakes
Using built-in functions like SUM instead of the add-on function.
✗ Incorrect
The formula calls the add-on function MYFUNC with cell A1 and A2 as arguments.
5fill in blank
hardFill 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'
Attempts:
3 left
💡 Hint
Common Mistakes
Using wrong file names or titles, or setting width too small or too large.
✗ Incorrect
The script loads the HTML file named 'Sidebar', sets the sidebar title, and width 400 pixels.