Bird
Raised Fist0
Google Sheetsspreadsheet~8 mins

Add-ons and extensions in Google Sheets - Dashboard Guide

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Dashboard Mode - Add-ons and extensions
Dashboard Goal

Help users understand how to use add-ons and extensions in Google Sheets to enhance their spreadsheet capabilities, automate tasks, and add new features.

Sample Data
TaskStatusDue DatePriorityNotes
Prepare reportIn Progress2024-06-10HighUse add-on for charts
Data cleanupNot Started2024-06-15MediumTry extension for duplicates
Send emailsCompleted2024-06-05LowAutomated with add-on
Budget reviewIn Progress2024-06-12HighUse extension for formatting
Team meetingScheduled2024-06-08MediumCalendar add-on linked
Dashboard Components
  • KPI Card: Count of tasks by status using =COUNTIF(B2:B6, "Completed") and similar formulas for other statuses.
  • Table: Task list showing all columns for overview.
  • Instruction Box: Text explaining how to install and use add-ons and extensions in Google Sheets.
  • Button (Simulated): Link to Google Workspace Marketplace for add-ons.
Dashboard Layout
+----------------------+----------------------+
|      KPI Cards       |   Instruction Box    |
|  (Task Status Count) |  (Add-ons Guide)     |
+----------------------+----------------------+
|                      Task List Table             |
|                                                  |
+--------------------------------------------------+
|               Button: "Get Add-ons"              |
+--------------------------------------------------+
Interactivity

Users can filter the task list by status using built-in Google Sheets filters. The KPI cards update automatically based on the filtered data. The instruction box and button remain static to guide users on add-ons usage.

Self Check

Add a filter to show only tasks with status "In Progress". Which components update?

  • The KPI cards update to show counts only for "In Progress" tasks.
  • The task list table shows only tasks with status "In Progress".
  • The instruction box and button remain unchanged.
Key Result
A dashboard showing task status counts and guidance on using Google Sheets add-ons and extensions.

Practice

(1/5)
1. What is the main purpose of add-ons in Google Sheets?
easy
A. To change the spreadsheet's background color
B. To add new tools and features without writing code
C. To create charts manually
D. To delete rows automatically

Solution

  1. Step 1: Understand what add-ons do

    Add-ons provide extra tools and features that are not built-in by default.

  2. Step 2: Compare options with add-ons purpose

    Only To add new tools and features without writing code describes adding new tools without coding, which matches add-ons' purpose.

  3. Final Answer:

    To add new tools and features without writing code -> Option B

  4. Quick Check:

    Add-ons = new tools without coding [OK]
Hint: Add-ons = extra tools without coding [OK]
Common Mistakes:
  • Thinking add-ons change colors only
  • Confusing add-ons with manual chart creation
  • Assuming add-ons delete data automatically
2. Which menu in Google Sheets do you use to install add-ons?
easy
A. Extensions
B. File
C. View
D. Insert

Solution

  1. Step 1: Recall where add-ons are installed

    Add-ons are installed from the Extensions menu in Google Sheets.

  2. Step 2: Match the correct menu option

    Among the options, only Extensions is the correct menu for add-ons.

  3. Final Answer:

    Extensions -> Option A

  4. Quick Check:

    Install add-ons from Extensions menu [OK]
Hint: Add-ons come from Extensions menu [OK]
Common Mistakes:
  • Choosing File menu instead of Extensions
  • Selecting Insert or View menus incorrectly
  • Not knowing where to find add-ons
3. You installed an add-on that automatically formats dates in your sheet. What will happen when you enter a date like 3/14/2024?
medium
A. The date will stay as plain text without changes
B. The sheet will show an error message
C. The add-on will format the date according to your chosen style
D. The date will be deleted automatically

Solution

  1. Step 1: Understand add-on behavior

    The add-on is designed to format dates automatically when entered.

  2. Step 2: Predict the effect on date input

    When you enter a date, the add-on changes its appearance to the chosen format, not deleting or ignoring it.

  3. Final Answer:

    The add-on will format the date according to your chosen style -> Option C

  4. Quick Check:

    Date formatting add-on changes date style [OK]
Hint: Add-ons automate tasks like formatting [OK]
Common Mistakes:
  • Thinking add-ons delete data
  • Assuming no change happens to input
  • Expecting error messages from formatting add-ons
4. You installed an add-on but it does not appear in the Extensions menu. What is the most likely reason?
medium
A. Add-ons only work on mobile apps
B. Google Sheets does not support add-ons
C. You need to refresh the browser to see the add-on
D. The add-on was not installed properly or needs authorization

Solution

  1. Step 1: Check installation and permissions

    If an add-on is missing, it often means it was not installed fully or needs permission to run.

  2. Step 2: Evaluate other options

    Google Sheets supports add-ons, refreshing may help but usually authorization is needed, and add-ons work on desktop, not only mobile.

  3. Final Answer:

    The add-on was not installed properly or needs authorization -> Option D

  4. Quick Check:

    Missing add-on = install or authorize issue [OK]
Hint: Missing add-on? Check install and permissions [OK]
Common Mistakes:
  • Assuming Google Sheets lacks add-on support
  • Ignoring authorization prompts
  • Thinking refresh alone fixes missing add-ons
5. You want to automate sending emails from Google Sheets using an add-on. Which of these steps is NOT required?
hard
A. Write complex scripts manually in the sheet
B. Authorize the add-on to access your Gmail account
C. Install an email automation add-on from Extensions
D. Set up the email template and recipient list in the add-on

Solution

  1. Step 1: Understand add-on automation

    Add-ons automate tasks without needing manual script writing.

  2. Step 2: Identify unnecessary step

    Writing complex scripts manually is not needed because the add-on handles automation.

  3. Final Answer:

    Write complex scripts manually in the sheet -> Option A

  4. Quick Check:

    Add-ons automate without manual scripts [OK]
Hint: Add-ons save scripting effort [OK]
Common Mistakes:
  • Thinking manual scripts are needed with add-ons
  • Skipping authorization steps
  • Not setting up templates in add-ons