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.

Practice

1. What is the main purpose of using the Template Gallery in Google Sheets?

easy

A. To start a new spreadsheet quickly with a ready-made design

B. To write complex formulas automatically

C. To share spreadsheets with others

D. To convert spreadsheets into PDFs

Solution

1. Step 1: Understand what templates provide

   Templates offer pre-built spreadsheet layouts to save time.

2. Step 2: Identify the main use of Template Gallery

   The gallery helps users pick these ready-made spreadsheets quickly.

3. Final Answer:

   To start a new spreadsheet quickly with a ready-made design -> Option A

4. Quick Check:

   Templates = Quick start with ready-made sheets [OK]

Hint: Templates = ready-made sheets for fast start [OK]

Common Mistakes:

• Thinking templates create formulas automatically
• Confusing templates with sharing features
• Assuming templates convert file formats

2. Which step correctly describes how to open the Template Gallery in Google Sheets?

easy

A. From the Google Sheets home page, click on 'Template Gallery' at the top

B. Go to 'Edit' > 'Templates' menu

C. Open a blank sheet and type 'template' in any cell

D. Click on 'File' > 'Import' > 'Template Gallery'

Solution

1. Step 1: Locate Template Gallery on Google Sheets home page

   The Template Gallery button is visible at the top of the home page.

2. Step 2: Confirm correct navigation method

   Clicking this button opens the gallery to pick templates.

3. Final Answer:

   From the Google Sheets home page, click on 'Template Gallery' at the top -> Option A

4. Quick Check:

   Template Gallery location = home page top [OK]

Hint: Find Template Gallery on Google Sheets home page top [OK]

Common Mistakes:

• Looking for templates inside 'File' menu
• Trying to type 'template' in cells
• Searching under 'Edit' menu

3. You select a 'Monthly Budget' template from the Template Gallery. What will you see immediately after opening it?

medium

A. A blank spreadsheet with no data

B. A pre-filled spreadsheet with budget categories and formulas

C. A pop-up asking to create a new Google account

D. A spreadsheet with only text instructions and no formulas

Solution

1. Step 1: Understand what templates contain

   Templates like 'Monthly Budget' come with preset categories and formulas.

2. Step 2: Identify what appears after opening the template

   You get a ready-to-use sheet with data and calculations, not blank or just instructions.

3. Final Answer:

   A pre-filled spreadsheet with budget categories and formulas -> Option B

4. Quick Check:

   Templates = pre-filled sheets with formulas [OK]

Hint: Templates come pre-filled with data and formulas [OK]

Common Mistakes:

• Expecting a blank sheet
• Thinking templates only have instructions
• Believing a new account is needed

4. You opened a template but the formulas are not calculating. What is the most likely reason?

medium

A. You need to install an add-on to use templates

B. The template does not contain any formulas

C. Google Sheets is offline and cannot calculate formulas

D. You forgot to enable editing after opening the template

Solution

1. Step 1: Check template editing status

   Templates open in view-only mode until you enable editing.

2. Step 2: Understand formula calculation requirement

   Formulas calculate only when editing is enabled; otherwise, they appear static.

3. Final Answer:

   You forgot to enable editing after opening the template -> Option D

4. Quick Check:

   Enable editing to activate formulas [OK]

Hint: Always enable editing to activate formulas [OK]

Common Mistakes:

• Assuming templates lack formulas
• Thinking offline mode disables formulas permanently
• Believing add-ons are required for templates

5. You want to customize a 'Project Timeline' template to fit your team's schedule. Which of the following is the best approach?

hard

A. Download the template as Excel and edit offline only

B. Edit the template directly after opening it from the gallery

C. Make a copy of the template and then customize the copy

D. Use the template without changes to keep it original

Solution

1. Step 1: Understand template editing restrictions

   Templates open as view-only; direct edits are not saved to the original.

2. Step 2: Choose the best way to customize

   Making a copy lets you edit freely without affecting the original template.

3. Final Answer:

   Make a copy of the template and then customize the copy -> Option C

4. Quick Check:

   Copy template before customizing [OK]

Hint: Copy template first, then customize safely [OK]

Common Mistakes:

• Trying to edit original template directly
• Downloading instead of copying
• Not customizing to fit needs