Custom functions in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a custom function in Google Sheets?

A custom function is a special formula you create yourself using Google Apps Script to do tasks that built-in functions can't do.

beginner

How do you start writing a custom function in Google Sheets?

Open the Extensions menu, choose Apps Script, then write a JavaScript function that starts with the keyword function and returns a value.

beginner

What must a custom function always do to work correctly in a cell?

It must return a value. The returned value is what you see in the cell where you use the function.

intermediate

Can custom functions in Google Sheets change other cells or the spreadsheet structure?

No, custom functions can only return values to the cell they are called from. They cannot change other cells or the sheet layout.

beginner

How do you use a custom function once it is created?

Just type its name like a normal formula in a cell, for example =MYFUNCTION(A1), and it will run and show the result.

Where do you write a custom function for Google Sheets?

A Directly in a cell

B In the Extensions > Apps Script editor

C In the Google Docs document

D In the Google Drive settings

Custom functions are written in the Apps Script editor accessed from Extensions > Apps Script.

What must a custom function always do to work properly?

A Return a value

B Change other cells

C Send an email

D Open a popup window

Custom functions must return a value to display in the cell where they are used.

Can a custom function modify other cells in the spreadsheet?

A Yes, always

B Only if you have admin rights

C No, never

D Only on weekends

Custom functions cannot change other cells or the spreadsheet layout.

How do you call a custom function in a sheet cell?

A By typing its name with an equal sign, like =MYFUNC()

B By clicking a button in the toolbar

C By right-clicking the cell

D By opening the script editor

You use custom functions just like built-in ones, starting with = and the function name.

Which language do you use to write custom functions in Google Sheets?

A HTML

B Python

C SQL

D JavaScript

Google Sheets custom functions are written in JavaScript using Google Apps Script.

Explain how to create and use a custom function in Google Sheets.

Think about the steps from writing code to using it in a cell.

What are the limitations of custom functions in Google Sheets?

Focus on what custom functions cannot do compared to scripts.