Template gallery usage in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to open the Template Gallery in Google Sheets.

Google Sheets

Go to the [1] menu and select 'Template Gallery'.

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

AFile

BEdit

CView

DInsert

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing the Edit menu instead of File.

Looking under View or Insert menus.

In Google Sheets, the Template Gallery is accessed from the File menu.

2fill in blank

medium

Complete the code to select a template category in the Template Gallery.

Google Sheets

Click on the [1] tab to see templates for budgets, calendars, and more.

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

AHelp

BHome

CSettings

DCategories

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting Home tab which shows featured templates only.

Choosing Settings or Help which are unrelated.

The Categories tab shows different template types like budgets and calendars.

3fill in blank

hard

Fix the error in the instruction to create a new spreadsheet from a template.

Google Sheets

After selecting a template, click [1] to open it as a new spreadsheet.

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

ASave

BDownload

CUse this template

DEdit

Attempts:

3 left

💡 Hint

Common Mistakes

Clicking Download which saves a copy locally.

Clicking Save or Edit which do not create a new file from template.

Clicking Use this template creates a new spreadsheet from the chosen template.

4fill in blank

hard

Fill both blanks to describe how to find a specific template by name.

Google Sheets

Use the [1] box at the top of the Template Gallery and type the [2] of the template you want.

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

Asearch

Bfilter

Cname

Dcategory

Attempts:

3 left

💡 Hint

Common Mistakes

Using filter instead of search box.

Typing category instead of template name.

The search box lets you type the name of the template to find it quickly.

5fill in blank

hard

Fill all three blanks to explain how to save a template you created.

Google Sheets

To save your spreadsheet as a template, go to [1] > [2] > [3] Template.

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

AFile

BMake a copy

CSave as

DSubmit

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Submit which is not a menu option.

Confusing Save as with Make a copy order.

You save a template by going to File > Save as > Make a copy Template.