Google Apps Script - Exercise Coding Projects - How to Create Custom Functions in Sheets with Google Apps Script Code

This video tutorial covers the creation and use of custom functions in Google Apps Script, focusing on both simple and complex examples. It explains how to handle numeric and string inputs, use built-in functions, and integrate Google Maps API for location data. The tutorial also provides guidelines for naming functions and best practices for using them in Google Sheets.

What is the primary advantage of using Google Apps Script for custom functions?

• It restricts the use of built-in functions.

• It allows for the creation of static spreadsheets.

• It enables the creation of customized functions with dynamic outputs.

• It only supports numeric inputs.

What is the first step in setting up a Google Sheets environment for custom functions?

• Create a new spreadsheet in Google Drive.

• Open an existing spreadsheet.

• Download a template from the internet.

• Create a new Google Doc.

What does the 'my custom' function do with the input value?

• Subtracts 5 from the input value.

• Divides the input value by 2.

• Multiplies the input value by itself and adds 10.

• Adds 10 to the input value.

How does the 'my doubler' function handle range inputs?

• It averages the range before processing.

• It sums the range before processing.

• It returns an error because it cannot handle range inputs.

• It processes each cell in the range individually.

What is a key guideline for naming custom functions in Google Apps Script?

• Names must end with an underscore.

• Names must be lowercase.

• Names must include numbers.

• Names must be distinct from built-in functions.

What does the 'full name' function do with its two arguments?

• It multiplies them together.

• It adds them as numbers.

• It concatenates them into a single string.

• It subtracts the second from the first.

How is the sales tax calculated in the custom function?

• By adding a fixed amount to the input.

• By multiplying the input by a tax rate.

• By dividing the input by a tax rate.

• By subtracting a fixed amount from the input.

What is the purpose of the 'lot and launde find' function?

• To calculate sales tax.

• To concatenate two strings.

• To sum a range of numbers.

• To find the latitude and longitude of a location.

What happens if the 'lot and launde find' function cannot find a location?

• It throws an error.

• It returns zero.

• It returns a default location.

• It returns 'not found'.

What is a benefit of using custom functions in Google Apps Script?

• They are limited to numeric calculations.

• They are slower than built-in functions.

• They can only be used in Google Docs.

• They provide access to Google API functionalities.