Bird
Raised Fist0
Google Sheetsspreadsheet~5 mins

Add-ons and extensions in Google Sheets - Cheat Sheet & Quick Revision

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
Recall & Review
beginner
What is an add-on in Google Sheets?
An add-on is a small app you can add to Google Sheets to get extra features that are not built-in. It helps you do tasks faster or add new tools.
Click to reveal answer
beginner
How do you install an add-on in Google Sheets?
Click on the 'Extensions' menu, then choose 'Add-ons' > 'Get add-ons'. Search for the add-on you want, then click 'Install'.
Click to reveal answer
beginner
What is the difference between an add-on and a built-in feature?
Built-in features come with Google Sheets by default. Add-ons are extra tools you add yourself to do special tasks not included by default.
Click to reveal answer
intermediate
Can add-ons access your Google Sheets data?
Yes, add-ons can access your sheet data to work properly. Google asks for your permission before installing to keep your data safe.
Click to reveal answer
beginner
What is an example of a popular Google Sheets add-on?
One popular add-on is 'Power Tools' which helps with cleaning data, removing duplicates, and other handy tasks.
Click to reveal answer
Where do you find add-ons in Google Sheets?
AExtensions menu
BFile menu
CView menu
DHelp menu
What must you do before an add-on can access your data?
AGive permission when installing
BNothing, it accesses automatically
CRestart Google Sheets
DShare your sheet publicly
Which of these is NOT true about add-ons?
AThey add new features
BThey are built into Google Sheets by default
CYou install them yourself
DThey can help automate tasks
What is a common use for add-ons in Google Sheets?
AChanging font colors only
BSaving files offline
CAdding new formulas and tools
DPrinting sheets
How can you remove an add-on you no longer want?
ADelete the sheet
BClose Google Sheets
CClear browser cache
DUninstall from Extensions > Add-ons > Manage add-ons
Explain what add-ons are in Google Sheets and how they can help you.
Think about small apps that add new tools to your sheet.
You got /4 concepts.
    Describe the steps to install and remove an add-on in Google Sheets.
    Focus on the Extensions menu options.
    You got /4 concepts.

      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