Add-ons and extensions in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Using an Add-on to Clean Data

You have a Google Sheet with messy data including extra spaces and inconsistent capitalization. You want to use an add-on to clean this data quickly. Which add-on feature would help you remove extra spaces and standardize text case?

A Use the 'Remove Duplicates' add-on to clean spaces and fix capitalization.

B Use the 'Chart Builder' add-on to visualize text data.

C Use the 'Translate' add-on to convert text to uppercase.

D Use the 'Power Tools' add-on to trim spaces and change text case.

💡 Hint

Think about an add-on that offers multiple text cleaning tools like trimming spaces and changing case.

The 'Power Tools' add-on includes features to trim spaces and change text case, making it ideal for cleaning messy text data.

❓ Function Choice

intermediate

Choosing the Right Add-on for Data Validation

You want to add advanced data validation rules beyond what Google Sheets offers by default. Which add-on would best help you create custom validation rules?

A Use 'Autocrat' add-on to automate document creation.

B Use 'Advanced Find & Replace' add-on to create validation rules.

C Use 'Data Validation Helper' add-on to build custom validation rules.

D Use 'Form Publisher' add-on to validate form responses.

💡 Hint

Look for an add-on focused on data validation and rules.

'Data Validation Helper' add-on is designed to help create and manage custom data validation rules in Google Sheets.

📊 Formula Result

advanced

Output of a Custom Function from an Add-on

You installed an add-on that provides a custom function =EXTRACTEMAILS(A1:A5) which extracts all email addresses from the range. If A1:A5 contains:

• A1: "Contact: [e-mail]"
• A2: "No email here"
• A3: "Email: [e-mail]"
• A4: ""
• A5: "Reach us at [e-mail]"

What will be the output of =EXTRACTEMAILS(A1:A5) in a single cell?

A "[e-mail] [e-mail] [e-mail]"

B "[e-mail], [e-mail], [e-mail]"

C "[e-mail]; [e-mail]; [e-mail]"

D "[e-mail]\[e-mail]\[e-mail]"

💡 Hint

Think about how add-ons usually separate multiple extracted items in one cell.

Most add-ons return multiple extracted emails separated by commas and spaces in a single cell.

❓ data_analysis

advanced

Analyzing Add-on Impact on Sheet Performance

You installed an add-on that runs a script to update your sheet every minute. After installation, your sheet becomes slow and sometimes unresponsive. What is the most likely cause?

A The add-on's script triggers too frequently, causing performance issues.

B The add-on is incompatible with your browser version.

C The add-on is using too many custom formulas causing recalculation delays.

D The add-on is deleting important data causing errors.

💡 Hint

Think about scripts running often and how that affects sheet speed.

Scripts that trigger very frequently (like every minute) can slow down the sheet by constantly running updates.

🧠 Conceptual

expert

Security Considerations When Using Add-ons

When installing third-party add-ons in Google Sheets, what is the most important security practice you should follow?

A Only install add-ons from trusted sources and review permissions carefully.

B Always grant full access to your Google account to ensure add-ons work properly.

C Disable all add-ons after use to prevent data loss.

D Share your sheet with the add-on developer for better support.

💡 Hint

Think about protecting your data and privacy when using external tools.

Installing add-ons only from trusted sources and reviewing permissions helps protect your data and privacy.